Power Query: Create column from cell value in table column

Hi everyone,

I find myself in a bit of a pickle after trying several options without any success. So here I am with a problem that I sincerely hope someone can help me with.

I imported multiple excel files from a folder, each with multiple sheets all formatted the same way.

After some initial transformations, I arrive at a table identifying the name of each sheet from each file [Model Name], and the relative table column [Excel.Data]. Before expanding the table column, I would like to generate a custom column that reads the specific value in a cell within those tables (the same everywhere), specifically the cell E1 in the excel sheets.

In pictures, here is where I arrive.

Problem

And here is what I would like to get.

Expected solution

The similar post I have seen all related to a cell in multiple files but I couldn't find anything about a cell in all sheets of multiple files. As if this adds a level a complexity I cannot seem to be able to untangle by myself.

Any help and suggestion would be greatly appreciated!