Refer the below link

http://msdn.microsoft.com/en-us/library/cc793964.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Kat" wrote:

Is there a way for me to create a summary sheet from several worksheets to
one main worksheet directory. I have multiple POC list worksheets and need
to have them roll up into one worksheet as they are updated on their tab.
this will help save my team membes from having to enter the data twice. so
that when something changes on one it will automatically update?