I need a vba macro that would copy the first sheets of the 4 differant/seperate worksheet that are located in C:\workbook into the current open worksheet that has already 4 tabs inserted into it. The macro needs to copy the worksheets located in the C drive that were created within the last 1 hour. Because there will be other worksheets with the same name that were created in the past 4-5 hours within the same location (in the C drive).
Also, while the macro copies the sheets, it needs to copy all the content of them into the current open excel document. Experts please help :)