Linking table data from 1 sheet into another

Hi guys,

Attached is a sample file. On the sheet titled "Conference Stats" are long countif and countifs formulas in columns titled "Tourney App.", "Amount" and "Wins". I chose to remove them from the example because they make the workbook too large to upload, but you can reference them from post 16 of https://www.excelforum.com/excel-for...e-pages-2.html. Much thanks to Cantosh for the help!! It took some time.

There are a lot of these formulas in the "Conference Stats" page and it's creating a lag when calculating and loading the workbook. I'd like to find a way to lessen the calculating and loading times. Since these countifs formulas are counting data contained in the tables (Range D:N) on pages 2-8 (titled #1 vs #16, #2 vs #15 up to #8 vs #9) I thought that if i could copy all the tables to another sheet ("Linked") i could edit the countifs formulas from scanning 8 pages to only scanning 1. So here are my questions:

1. Can this be done, and if so, how? Remember that the tables in the pages 2-8 will have new data added each year so if the tables are copied to another sheet per say, they would have to account for future updates.

2. Will doing this lessen the calculation and loading times?

3. Are calculation and loading times due to the sheer length of formulas or the complexity of the formula? More specifically does my workbook lag because the countifs are long, or that the countifs have to scan 8 different pages?

Thank you in advance!