Making a "If" function work with a sheet tab name?

I have a macro that makes a sheet. In this case it's "Adder 2, 3... etc." Adder sheet 1 is existing. By clicking the "Add" button you can make new "Adder" tabs, the second adder tab...

excel

Formulas and Functions

Budman361530

Brass Contributor

Oct 01, 2022

NikolinoDE,

I downloaded your recommendation, but cannot find what I am trying to do. Not sure if I am explaining correctly, so I made a sample workbook. See attached. Ultimately, I am trying to get the values in Cells C4 through C8 to populate in the corresponding "Adder" sheets cell C5, when you click the "Button #1". I tried INDIRECT Function, IF function, MATCH, VLOOK UP. Not sure if I did them wrong, or they are not the correct functions?

=INDIRECT('Summary Page'!B4:B8&" '!")

=IF(INDIRECT('Summary Page'!B4:B8&" '!"),'Summary Page'!C4:C8," ")

=IF(MATCH(" '!",'Summary Page'!B4:B8),'Summary Page'!C4:C8," ")

=VLOOKUP(" '!",'Summary Page'!B4:C8,2,0)