How do I combine data from several sheets into one main sheet?

[Caren F]

I am attempting to combine data from several worksheets into one sheet for
analysis. Other than copying and pasting each sheet, is there another way to
do this? Once combined I will be doing a pivot table to capture the
information I need.


Thanks,