Excel: Copy list of workbooks ( one sheet only) to one workbook in tab number order

Can anyone assist with a formula. Take a list of workbooks ( only1 worksheet in each workbook) say the workbooks are held in the y:\ and called 1980-001,1980-002 up to 1980-250 I want to copy all these individual workbooks to one workbook in tabs in file number order. So the first tab would be 1980-001 the next tab would be 1980-002 and so on depending o how many workbooks there are. My formula doe this but does not add the workbook name to the tab and also does not copy them over in number order. Any help greatly appreciated

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of July 17, 2014.

For more resources for Microsoft Excel