I have a master spreadsheet that contains 100 worksheets, the worksheets are named 100-200.
I have 100 separate spreadsheets named 100.xls to 200.xls. Each of those spreadsheets has just one worksheet and I'm wanting to link or import the data from those worksheets into the corresponding worksheet on my master i.e. the data from 100.xls will go into the worksheet named 100 on my master spreadsheet.
Is there any easy way of doing this?
Bookmarks