I know the steps, but not the proper code to accomplish my intended
result.

Greg
AA2e72E wrote:
Some hints:

1. Use Scripting.FileSystemObject to recurse through your sub folders, to
enumerate and identify the last modified workbook in each.

2. Use Excel.Application to create your Summary workbook and to loop through
your list of workbooks from step 1.

3. Use Move (see help) to move Sheet(1) to the summary WB: take care not to
save the WB you are copying from.