Excel reference another cell on different sheet based on date

I am working on auto-populating a excel spreadsheet based off of 0+12 forcasts. Basically what I need it to do is check for the date and chose a row of 12 numbers based off that date from a details sheet to a summary sheet.

I am attempting to add nested if's that will determine what lines to reference on the other sheet. I am using the =today formula with =month to return the month as a numeric date in a reference cell (A1) for simplicity. The first sheet is "summary" and I am trying to pull from "test"So the formula I am using is:

=(if(A1=1,=test!A1,if(A1=2,=test!A2,if(A1=3,test!A3,... ect

I am also ending it as the last "if" being the month of December. I would plan on copying the formuala for each column (A - L) once I can get it to work for one.

Thank you! PS: Noticed Similar questions but not quite applicable (I do not believe a Vlookup would work)