Moving a cell reference using a formula and a variable?

Hi,

I have a advanced question that I cannot wrap my head around. Looking at the attached picture you can get a feel for what I am trying to accomplish. Where it says input I want to be able to type a number from 1-12 and have the cells in row 16 (Columns C/D respectively) return a specific cell reference as pertains to the input. For example if I input a 1 I want cell C16 to return a cell reference to the matching month (January). I am sorry if I explained this poorly it is quite difficult to understand what I am trying to do. Any help would be greatly appreciated!

Thanks,
Amitus

Capture.PNG

I uploaded an example book. What I am trying to do is on the sheet "CONTROL" where it says input I would type a number from 1-12. This would then prompt the cells in row 394 of sheet "Vacaction Current" to match the input number, which is basically a month i.e. 1 would be January, and create a cell reference to the corresponding row. Again if I explained that poorly please let me know and I will try to be more clear. Thanks again for the help.

I apologize, instead of input look where it says Period on the sheet "CONTROL".

In my case I do not believe the date should matter. The listed months on "Vacation Current" can be thought of as placeholders for the numbers 1-12. By typing in the Period number, 1, I want the cell in C394 to say "=C381" which can be thought of as the month of January if you please. So to continue, if I typed a 2 into the Period, the cell in C394 would change to say "=C382" due to the fact that I am now referring to the month of February. I want this to be done with a formula, but I am sure I could use a macro. Was this explanation a bit easy to understand?

I was trying to accomplish this task by using a VLOOKUP by having the number in Period be the lookup value. This value would then be used to match which row I want the cell reference to refer to. What I mean by this is when I type that 1, that means I want the row "January" and I want my cell in C394 to state "=C381". If I instead type a 2 then its referring to the row "February" and would state in cell C394 "=C382". Hopefully my further explanations are narrowing this down haha. Thank you for your time FDibbins.