Hello I have multiple workbooks in various locations, each workbook as a summary sheet called summary, I want a master summary sheet to collate all the data from these sheets.
I've attached an example of how I would like the master sheet to look and an example of the summary on all the workbooks.
The sheet needs to update by either an update command button or automatically when the master sheet opens.
all the other workbooks may be opened or closed and may be read only if someone is in them, but we can assume that the workbooks will be closed if that helps.
I need this in VBA if possible ,