Hi all,

I would really appreciate it if someone could give me advice on if the following is possible.

I will be saving files into one folder in the following manner:

Project ABC June report (Sheets = mikes summary, mikes budget, mikes risks)
Project DEF June report (Sheets = john summary, john budget, john risks)
Project XYZ June report (Sheets = jane summary, jane budget, jane risks)

The number of files may vary month by month depending on projects on the go.

I would like to create a master file that has a macro in it that pulls the first sheet (and only the first sheet) from each of the other workbooks and keeps them in individual sheets in the master document.

So the master document would look like

Master document (Sheets = Mikes summary, Johns summary, janes summary etc)

Is this do-able?

Thanks in advance for looking at it.