could not see the tables you showed above?
table calculations work on the table that underlays each worksheet individually - to use them on a common sheet the single sheet needs to include all the data and teh table calcs need to be created on that sheet
I.e. you can not transfer table calc results from one sheet to another
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.