Why not just have ONE worksheet with a column for the week and then use
datafilterautofilter to filter as desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bearcat Fan" <Bearcat wrote in message
...
I am not sure if this will make sense but I am trying to have worksheets to
connect. I will have 52 worksheets with week 1 and so on. And then in my
worksheets I will have a name and how many hours they are at a certain
place
from Monday to Friday. So then in worksheet 2 and so on I want the hours
to
add up from week to week on each of the 52 worksheets. If you anyone
could
help me that would be great and thanks.