Hi All

Firstly, thank you all for your help - I've been reading the forum for some time but only now have not been able to find the solution to my problem.

I have created a book to keep track of contracts. I have an oboarding sheet which I enter the details of the new contract and then I have a macro which moves it into my active sheet.

With more contracts I have had to separate these out into other sheets based on the name of the client.

What I want to do is have a cell on the onboarding sheet which I can enter the name of the sheet and have the contract placed into that sheet.

My VB code is:

Sheets("Active").Select
Rows("2:2").Select
Selection.Insert Shift:=xlDown
Selection.Font.Bold = False
Sheets("Onboarding").Select
Range("C2:C16").Select
Selection.Copy
Worksheets("Active").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Range("A2").Select
Sheets("Onboarding").Select
Application.CutCopyMode = False
Range("C2:C16").Select
Selection.ClearContents
Range("C2").Select


The bold sections are where I would like to put the name of the sheet from the cell. The cell with the name in is C20, I have tried the obvious:

Sheets("C20").Select

Sheets(C20).Select

And some indirect function, but these don't seem to work - any ideas?