Advanced linking of workbook to another workbook

[ifeelalone]

I hope I explained what I need here. So this is how it goes.


1. On Workbook A, I have a cell B4 - B7. The values are populated from Workbook B - sheetname "Fruits", cell C4 - C7


2. On workbook A again, I have cell B11 - B13. The values are populated from Workbook C - sheetname "Vegatables", cell C11 - C13


3. All workbooks are in the same path with different file name,
Workbook A filename: ListSummary.xlsx
Workbook B filename: ListFruits.xlsx
Workbook C filename: ListVegetables.xlsx


4. On Workbook A, is there a way i can paste the path and the corresponding workbook name on a cell so when I hit refresh button, the values are updated?


Please let me know if this is clear thanks in advance!

 

[ifeelalone]

forgot to mention, workbooks b and c filename are changeable over time.