First i know the title is quite vague, for what i want to happened is somewhat hard to explain in a few words.
showing you with screen shots what i want to happen might help a lot.


i have this path of folders
folders.PNG


and i found a macro over the net to make the folders like this

template.PNG


in sheet1 has all the list of the folders, from there it copied Template and renamed the worksheets based on sheet1 the list on column A represented vertically.

sheet1.PNG

now per folder has excel files in them, i want it to be opened automatically and there i will run a macro i did myself for the following task, macro will do copy and pasting on the excel files and on the worksheet where the folder was opened.
1. open ALL excel files on the folder (Date MID BCC SENDER)
2. a recursive function thats like: Sheets("Date MID BCC SENDER").Select
3. execute my macro: Call myMacro

1.1 open ALL excel files on the folder (Date MID CC BCC)
1.2 a recursive function thats like: Sheets("Date MID BCC SENDER").Select
1.3 execute my macro: Call myMacro


of course this would be done in a bigger recursive function, i hope anyone can help me cause if you look closely i have around 1000 folders to work on