View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kat Kat is offline
external usenet poster
 
Posts: 56
Default take all data from several worksheets to one main worksheet?

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?