I am new to macros, but would like to use them for a project that I am
working. I need to build a spreadsheet that will populate automatically with
information from many different spreadsheets (which are all in the same
folder on a network and never move). This folder will be updated once a week
with a new spreadsheet. Is there a way to build a macro that will
automatically get specific information from these sheets and put that
information into one excel file (also in the same folder)? Ideally, I would
like to create a button that when pressed would update the sheet with new
information. Any help would be appreciated. Thanks.