First off...not too good with Access, which may be the answer...but, here goes.
I have data tables that have the exact same column headers in multiple sheets throughout a workbook. I can not consolidate these sheets to one page as there would be too many records.
I am doing many calculations on this data with sumifs, sumproducts, etc.
Is there another way to consolidate this data and still do these calculations on the detail?
I don't know if this makes sense, but hopefully it does.