Hi,
I wonder if anyone could please help
I have a number of excel files (approx ten, maybe a few more) which each contain a summary sheet on the first tab. (They all have different names but if need be I could rename them Sheet1)
Each summary sheet has a graph, commentary, key stats etc and the idea is to easily combine all the summary pages into one combined report.
I only want the first sheet of each document within the master document (the other data source tabs are not required)
All files are stored in the same folder.
My plan was to put them all in the same folder, create a new excel document containing vba to complete this function.
As an vba novice however, this is proving far more difficult than first anticipated!
If anyone could help in anyway it would be most appreciated!
Many thanks in advance
Bookmarks