Hi Versace !! :)
You can open all the daily Excel files in your
folder, if you know the file names.The rest of the solution is rather simple.
You can copy-move the particular sheets fromall the files to your new
workbook. This is done by checking all the sheets in the daily Excel file to
find the sheet to copy.

I hope this will help you !

Vijay

"Versace77" wrote:

Good evening,

This may be on the forums already but i must be searching for it wrong if it
is.

A daily Excel file is placed into a folder. I'd like to have the worksheet
from all the files within that folder to be copy/pasted into a new workbook.

Example, each file has a worksheet named ABCcurrent date. I want the new
file/workbook to contain it all, ABC092208, ABC092308, ABC092408, etc. This
would save alot of manual labor.

Thank you for any support you can provide.