i have 35 xl files with only one sheet in, i need to combine them into one workbook so each file has its own sheet and sheets are numbered from 1 to 35.
the file names are always different each week but all start with "data" and end with a 4digit number which goes up by 1 each week
thanks in advance..
the file names are always different each week but all start with "data" and end with a 4digit number which goes up by 1 each week
thanks in advance..