Hi there,

We run multiple projects and have trackers for our budgets. All of this information is visible on a summary page.

My manager would like to be able to import some of the values on these summary sheets into a master sheet, putting the vital stats from each project on a new line.

Can I add a 'Browse' button where he could click it, navigate to the new project's tracker and it would automatically import the vital stats from that tracker on the next available line?

I've attached an example summary tracker sheet, plus an example of the master sheet that my manager would want to import the data into. I've noted on the master for my manager which cells from the summary tracker I would want the data for.

I can see this being a one-step process for my manager, he simply selects the new project file and it imports all the info he needs! All projects will use the same template so the summary page will not change.

Sorry if this sounds confusing, happy to confirm things if there are any questions.

PS - I'm not well versed in VBA yet so if the solution uses it, a help on how to get started on it would be great.

Thanks!

Summary Tracker Example.xlsxManagers Master EXAMPLE.xlsx