Excel - Merge workbooks sheets

Closed - This job posting has been filled.

Job Description

We have the following to be done:

46 spreadsheets in 46 work books to merge into one worksheet
49 spreadsheets in 49 work books to merge into one worksheet

Therefore out put is two seperate worksheets.