Basically I am trying to import several different tabs from one Google Sheets doc and then have that data aggregated into a separate single tab on a different Google Sheets doc with an extra column indicating which sheet that data originally came from.

So for an example If my Aggregation sheet was here: