Merge/Copy Separate Sheets into One Workbook
 

Hi,

Started for ten needed please....

I've got multiple Workbooks sat in a directory each containing one
sheet, let's call them Project A - Time.xls, Project B - Time.xls and
Project A - Expenses, Project B - Expenses, etc. What I would like is
one workbook for each project each containing their respective sheets,
i.e. Project A.xls would contain a Time sheet and an Expenses sheet.

Any pointers would be great.

Thanks,

Jon C