There is a specific cell in the Jan Data spreadsheet that I need in the Jan Sales Tax spreadsheet and the same cell is needed from the Feb Data spreadsheet in the Feb Sales Tax spreadsheet and so on.

Here is the Formula in the Jan Sales Tax spreadsheet that I change every month to reflect the current month's need.

=+'[Jan Data.xlsx]Sheet1'!$A$7 Note: In Feb, I change "Jan" to "Feb", the remainder of the formula is not touched. Is there any way to make the "Jan" portion of the formula dynamic so that when I enter the applicable month in cell A1 - Jan or Feb or March, etc, the dynamic portion of the formula will change to whatever is in cell A1 thanks in advance!! |