VBA Newbie needs your help

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 ,
Example-sheet.xlsx
Chris NAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
You don't need VBA. Open master book and first summary book.
Enter = in first cell (C4), change window to summary workbook and select C4 cell in it, press ENTER.
You will have somethong like:
='C:\PathToWorkbooks\[Workbook-1.xlsx]Example of Summary Sheet'!$C$4
remove $ signs from C and 4:
='C:\PathToWorkbooks\\[Workbook-1.xlsx]Example of Summary Sheet'!C4
pull right bottom corner of cell down and right.
Repeat steps for all summary workbooks, starting from proper cell position
Look at sample. Change paths with built-in master
Example-sheet.xlsx
0
Chris NAuthor Commented:
But will the master workbook automatically update when the other “child” workbooks are updated, as if the “child” workbooks are closed then the information can’t be obtained. I can’t have all the workbooks opening.
0
als315Commented:
When you open master workbook, you will get message:
updatePress update and data will be updated even if summary files are not opened
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris NAuthor Commented:
Thank you for all your help, I’m sure I’ll be back with more questions.
0
Chris NAuthor Commented:
Works a treat, thank you Als315, you have saved me loads of searching and head scratching.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.