FDibbins:

tried directly entering the formula as you had it, kept getting the formula contains an error. i then entered
=INDIRECT("TBData["&E4&"]". the cell returned a number (no idea if its right) i then worked backwards by entering the sumifs before it, and Loe and behold... it WORKS!!!!!!!!!! changed the year to 2013 to verify its working, and viola, it DOES!!!!!!!

Thank you so much for your time. Now its just going take some time to copy the formula down, but the future will make my life so much easier!

Thanks again!!!!
(I'm just a little happy, in case you couldn't tell!)