Help with creating summary from multiple workbooks

[Rlyman1]

Hello,

I work in a field where we have multiple "Financial model" workbooks Ie "Project 1.xlsx" , "Project 2. xlsx", "Project 3. xlsx" all saved in different folders. These are all large files with multiple tabs.

I would like to create a Summary workbook that automatically pulls certain cells from each Project workbook and then populates to a single column per project in the new workbook. I would like to achieve this by either A) inserting a file path into the summary workbook or B) having some type of open file button within the summary workbook that allows me to select the correct file for each column. However the method I would also like to include a button that will also allow me to open the specific project file from the summary workbook.

The main key to this is not having to open the original project files each time to update the summary spreadsheet.

I am currently achieving this by copying each cell in the Project file and pasting a link to that cell into the summary. This becomes tedious when I have to do it 10-15 times and I'm sure there's a way to automate this in VBA. any help would be greatly appreciated

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...workbooks.html