need data to change from month to month

New to excel and what I have learned I have learned on my on except for a one day basic course. What I am trying to do is I have a spread sheet that has month actual, prior yr month, ytd actual and ytd prior yr. On my second sheet will have my actuals and my third sheet will have prior yr numbers. What I want to do is have a number at the top of the page (example 2 to represent July) then when I type in 3 that represents August my numbers will automatically change for the prior year and I don't have to keep putting them in every month. Hope this makes sense.

Hi,

You can try vlookup, as per what I understood of your issue that should suffice. Please attach the excel sheet so I can go through it and help you.

Warm regards
Ishtiyaq