Indirect referencing to a different worksheet&Table

My Apologies, One of the workbooks isn't shareable.

I made a couple replica versions.

See attached.

Originally Posted by Richard Buttrey

You'd be better advised to upload the two workbooks so that we can can check this in context.
Presumably you are aware that INDIRECT doesn't work unless the file referred to is Open?

It's also confusing since you say the formula that works refers to B2! which I presume means a sheet called whatever is held in B2. But B2 is the name of a file.

Im all sorts of confused.
But when i enter = and select the whole column in the 2010_Sold workbook I get:

='2010_Sold.xlsx'!January[Current Price]

It should be noted, that the sheet is called January and the Table is also called January.