I have workbooks that all have the same exact layout. Is there anyway to run a macro that will:
1) Prompt user to select workbooks within a folder (not a specific one - I believe this is the GetOpenFilename command)
2) Copy a range of values (for example A4 and C5:C28) from each worksheet within each workbook.
3) Paste the copied range (A4 from first workbook would go in B1 with the range C5:C28 from first workbook would go in B2:B25). Information from second worksheet/workbook would go in C1 AND C2:C25. Information from third worksheet/workbook would go in D1 AND D225, etc etc until there are no more workbooks or worksheets.
Essentially this is a summary worksheet...