Help with INDIRECT function

[Kemidan2014]

So i am wanting to do simple addition functions in a spreadsheet where i am referencing 2 cells from another WORKBOOK

but i want to modify the formula to make it dynamic across tabs which are in months, one tab is January one tab is February etc.

because in the new workbook im building i wanted to avoid making matching tabs and changing cell references
I wanted to set up a drop down list of data validation where verbage matches exactly how the tabs are named

I read using INDIRECT is a way to not have to hardcode the formula in but i think im just suffering from a Syntax issue where i am not properly keying in the formula

Picture is how the formula is currently when it works. simple "A +B" from Work book A into Work book B

Here is what im trying to do
=INDIRECT($A$2&$F$2&"'!"&K$63)+INDIRECT($A$2&$F$2&"'!"&K$64)

where A2 is the cell with the Directory and F2 is the value for the Tab name then the final cell is supposed to be the cell i want to add in the book (the days are columns in the referenced spreadhseet)

Overall idea is i can select the month and the formula results will change because the they now reference from another tab.

 

[jasonb75]

The cell references need to be in the double quotes.

=INDIRECT($A$2&$F$2&"'!K63")+INDIRECT($A$2&$F$2&"'!K64")

2 things to note.
The cell references inside the double quotes will always be absolute, even without the $ symbols. For relative references you will need to use R1C1 notation.
The workbook that the source data comes from must be open, INDIRECT can not be used with closed workbooks. As you have included the directory path, I assume that you wanted it to work with the other workbook closed.

 

[Kemidan2014]

aaah good to know. ill just do scrap the idea then