Hello, I was hoping there was a way of linking information on a sharepoint column to a value within a spreadsheet on Sharepoint.

So here's the way the information is laid out:

1) There is a file folder with a few columns to the right of it which state general information "at a glance" of what is in the Excel file itself, such as the due date, the team leader, etc... this is a manual column people edit.

2) Clicking into this folder on the left gets you to an Excel file and opening up that Excel file shows that same information, also manually entered. (See attached image)

3) I want to either
a) Link the Sharepoint column information to the various cells in Excel, to automatically update to the value within those cells when anything in the Excel is changed.
or
b) Link the Excel to reference the column information to pull in the information and populate the Excel whenever the excel file is opened.
Sharepoint Column.png
4) The file folders themselves are copied and pasted 100s of times to make new projects (which also copies the Excel file) so the solution should require a dynamic reference to the file location.

5) The filenames may change, but the location of the information within the file never changes from the cell location.