cant find formula to sort through multiple worksheets and extract specific data.

Hi

I have a spreadsheet which details all football players names, subs paid each weel and any outstanding subs owed. There is a separate sheet for each week which details those payers who played, subs paid and subs owed.

Is there a way where in another separate sheet it can automatically show what subs are owed and which players owe them? It would need to look at each week and add up in total for each player that owes subs.

The trouble i have is the players aren't the same each week, and the price of subs owed wont always be the same.

What I am after is to b able to see which players owe money and how much at a glance, without having to go through each tab.

Any help would be appreciated.

Thanks Becky :O)