I have a folder which has multiple files named 1.xls, 2.xls, 3.xls, etc
I have an input sheet which has a table like this:
Filename to be converted
1.xls one
2.xls two
3.xls three

The final excel after running macro should have 3 sheets as one, two and three with the data.

Any help on this is highly appreciated.