Moving to a sheet referenced in a cell

[brianfosterblack]

I have sheet named "Master". I then have a number of sheets named according to my Customer number 1001,1002,1003 etc.
I am entering information on the Master sheet which includes the client number in cell B2 on the Master sheet but in number format.
When I run a macro (still to be written) I want to copy what I have entered on the Master sheet in cell C2 to the next empty row on the Client sheet which is referenced in Cell B1 on the Master sheet. I can do the rest of the coding but do not know how to move to the sheet name entered in cell B2 in number format
Can someone please assist

 

[Fluff]

How about

Dim wsName As String
wsName = Sheets("Master").Range("B2").Value
Sheets(wsName).Select

 

[brianfosterblack]

How about

Dim wsName As String
wsName = Sheets("Master").Range("B2").Value
Sheets(wsName).Select

Thanks so much, this is perfect

 

[Fluff]

You're welcome & thanks for the feedback.