Copying to cell information

ExcelNumpty Posts 2 Registration date Monday August 24, 2015 Status Member Last seen August 26, 2015 - Aug 24, 2015 at 11:00 AM

I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The information is in the same file it is just on separate tab/sheet.

The example is below.

='TA 2015-16'!AI5+'BP 2015-16'!AI5+'RP 2015-16'!AI5