Merging multiple files into 1 worksheet

Hi... idiot question

I have 90 files that I need to merge into 1 worksheet with 90 worksheet tabs... I am aware of the move worksheet to function but this is v manual & I have to do this 90 times.... AND then replicate this again for another 5 situations... so near on 450 manual moves...

Any help appreciated :D

Hi,

If you were to place all your 90 files in a single dedicated directory, a macro could loop through this directory and follow your instructions ...

HTH
Carim