I need to create a report from several files with different names but from
the same cells in each file and paste them into a new file with the
information in specific locations and then calculate for totals etc...

How do I direct Excel to get the information? There may be a changing umber
of files but they will always be in the same folder.

Tom