Concatenating a name and number to reference a tab

[ericaljones]

I am working on a project where I have to reference different tabs of many rounds. I have formatted my index and match searches for the first round, but found that I was doing a lot of hard coding when trying to change each of the formulas for the "Round 2" tab.
Is there a way that I can combine the word "Round " with a number and reference the tab with that name?

 

[JoeMo]

Say you have three sheets with tab names Round 1, Round 2 and Round 3.

Sub CycleThruTabs()
Dim x
For x = 1 To 3
    Sheets("Round " & x).Select
     MsgBox ActiveSheet.Name
Next x
End Sub

 

[ericaljones]

I am more trying to use the concatenated tab name in other formulas. For example I want it to do =INDEX('Round 1'!B5:B41,MATCH('Erica Jones'!$A$1,'Round 1'!G$4:G$32,0))
Is there a way that I can replace the "Round 1" with a combination of "Round " and a number in that row that would represent the round number?

 

[JoeMo]

I am more trying to use the concatenated tab name in other formulas. For example I want it to do =INDEX('Round 1'!B5:B41,MATCH('Erica Jones'!$A$1,'Round 1'!G$4:G$32,0))
Is there a way that I can replace the "Round 1" with a combination of "Round " and a number in that row that would represent the round number?

Not sure I understand what row you are referring to.

Suppose you want to return the value of cell A1 in sheet Round 1, then if you have a 1 in cell G12 of any sheet where you want to reference that value. This formula will do that:

=INDIRECT("'Round "&G12&"'!A1")