This may be a little confusing to understand but in a simple word, I want to be able to extract selective data from Sheet2 into Sheet 1.
Example. in Sheet1 Cells A8:A50 are empty, I want to be able to either type in a sheet (name) into one of those columns and the sheet to extract data from Sheet2
UPDATED: Explanation with Images.
Here in the image one, you can see I am inside my Overview tab (Main Tab). I have selected a box around CELL A8. I would like to be able to type the Sheets name into CELL A8 from the Sheets I already own "AAPL", "DIS" or have the entire row automatically update every time a new Sheet is made.
Let's say, I typed AAPL inside CELL A8, I want the formula to automatically head inside the AAPL tab and grab content from there and bring it into the Overview TAB and paste it inside the box below the "Company Name"
Something like this, I know it's possible but it's beyond my ability and in need of some guidance on how to get this complete.
Update: A gentleman said this is possible using Google Script. I am new to the script side of this - anyone able to recreate something as to what I am asking I'll send you £10 via cashapp or PayPal as part of an appreciation for your effort. Unfortunately, I cannot share the script as it's my main stock portfolio.
Second Update: I have discovered the beautiful but yet simple function "=Sheet2!A1" - That grabs any information for Sheet2 and brings it straight into that Cell. With a little bit of creativity, it's working pretty well so far.