Indirect referencing to a different worksheet&Table

Originally Posted by lelliott7

Maybe im missing a simpler solution.

Indeed, maybe you are.

As I understand it you have data from different months spread across multiple workbooks. If so this really isn't the best approach.
As far as is practical you should always gather data that is the same layout, like monthly tables of information in the same workbook and in the same sheet, where you have a column that contains a reference to the month if that is not already part of your data.

How are you capturing your monthly data? Is it from some back office system? If so get that system to download all months rather than just one.
Otherwise use a macro to build the single table by looping through all the files and copying and pasting the data.