copy data from a range of worksheet

[Guest]

How can I copy data/compute data from multiple worksheet in sequence without
mentioning each of them individually?

thanks,

prashant.

 

[Guest]

hi,
use the activesheet.next.select command in a loop.

 

[Tom Ogilvy]

If they are days of the month

for i = 1 to 28
set sh = Worksheets(cStr(i))
msgbox sh.name
next