formula for copying from one sheet to another

[Guest]

I information that has been entered into one sheet, to automatically copy to
another sheet when it is updated. I am taking time card information from 10
sheets, and want to combine them into one summary sheet automatically. I
could really use some help! Thanks

 

[Don Guillett]

put the info in the same cell on each sheet then
=sum(yourfirstsheet:yourlastsheet!a2)

 

[Guest]

maybe i didnt word what i was trying to do properly. I dont need it to
"sum", i need it to copy the entire worksheet to a range of cells on my
"Totals" Page. So that each employee (they each have a seperate worksheet),
is listed on one page with each day, hours worked, cost codes etc. Thanks for
your help!

 

[Don Guillett]

then you should do all of them on the same sheet and use autofilter to
isolate.