Problem:
I have a folder where Excel files(.xls) are frequently being added and updated. I need to build a "dashboard" type Excel file that can:
1) look in this folder
2) find any Excel files
3) take a totals row from these files
4) add the totals rows in a single row on the Excel file I am creating.
Bookmarks