Merging Excel Worksheets

[Tony Gann]

Is there a program or method to merge multiple Excel files, I get
about 14 sales reports each month , each with the same header layout
data, and would like an easy method to merge them into one spreadsheet.
I would like ot do this without copying and pasting from each file to
the master file.

Thanks for any help.

Regards,
Tony

 

[Bob Greenblatt]

Check out help on "Consolidate". This will probably do what you want.