I attempted to build a pivot table to do this but the formatting will not do
what I need and there is to much data for the pivot table to handle. (It
runs out of columns with only 1/4 of the data on the table...)

I need to have a pull down menu at the top of the page with the 6 data tabs
as the options. I need my formulas to look on the tab that is selected.
Here is the formula in question:

=SUMPRODUCT(--('Data 1 Month'!$B$2:$B$12000=D2),--('Data 1
Month'!$H$2:$H$12000="1"))

So instead of 'Data 1 Month' I want it to check a cell that I specify, which
will be references to my data tabs, and look there.