How to create a linked workbook
By - CleanWeekend496
/u/CleanWeekend496 - Your post was submitted successfully.
Please read these reminders and edit to fix your post where necessary:
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Might want to clarify what you mean by "a bar" - do you mean a bar chart? Or a bar where someone eats? etc.
Sorry, yes a Bar as in a place to Eat/Drink
Sounds like a one drive folder containing your files and using PowerQuery's "files in a folder" setting would likely be your best bet to collate them. From there you can do whatever analysis is required.
The way I would approach this would be to add a bit of VBA code to each bar's individual file which would create a separate output file which would be sent to a central location, either shared drive or through Email each time the manager updates it, say, by clicking on a "share with home office" button.
Then you can take the 3 files, which are named, look and act the way you expect, and compile a master file from those, probably also using VBA.