Referencing the Sheetname problem

[mmopulencia]

Hello

I'm trying to do some cell referencing range like this one.

Sheets("IDNUMBER").Select
IDNEW = Sheet5.Range("A1")

now the challenge is, since ill be creating sheets as i go the Sheet number wont be constant. so i made a sheet to house all my sheetname and their corresponding number.

START UP (these are the actual Sheetname)	1​	Sheet1 (sheet numbers)
Registration	2​	Sheet2
Evaluation	3​	Sheet3
Update	4​	Sheet4
IDNUMBER	5​	Sheet5
SHEETNUMBERDB	6​	Sheet6

Sheets("SHEETNUMBERDB").Select (select the above sheet)
Sheetrangefordb = Range("C7").Value (i have an empty row 1, so this should output "sheet6")

now heres the things i tried

Sheetnumberdbrangefinder1 = Sheetrangefordb.Range("B1")
(this doesnt work)
Sheetnumberdbrangefinder1 = Sheetrangefordb & ".Range(""B1"")"
(this kinda works but instead of making at formula, it just outputs everything as a string "Sheet6.Range("B1")


so to cut it short i guess, I just want to be able to reference the Sheet number so itll out put Sheet6.Range("B1") , With Sheet6 as a non constant value.

Thank you in advance

 

[mmopulencia]

nevermind figured it out, instead of using Sheet6.Range and trying to call "Sheet6". i just used worksheet(x).range("B1") dumb mistakes hahaha.

 

[Alex Blakenburg]

I was wondering.