Need to distribute data from one worksheet to multiple spreadsheets.

Looking for help on a sport's team payment sheet where the first tab is a running list of all charges and payments and each subsequent tab are the individual player's account balance. I am using only the first tab to input data and the subsequent tabs to contain formulas. How do I have the tabs of individual player's account balance populated with data from the first tab?

Thanks Jeff, the CityInspector is clever but it doesn't work for my spreadsheet. I want to retain the entries on the payment tab yet distribute these to the appropriate tab. Also, my knowledge of VBA is non-existent. Was looking for cell formulas or array formulas to do the trick.

Is there a way to do this?