Hi

This is a bit of a confusing one so unsure how to word it.

I am creating a data sheet for cricket stats.
Sheet 1 is the record of the total datas for each particular players as it will continually update as i input data per game. That part is easy for one player (sheet 2). However, i will over time add new sheets for each player i have to input data for.

I will need to name the sheets the players name so i understand the formula will need each name for each sheet but i have 10-20 data set points that will need to be manually fixed and thats just time i do not want to waste.

So is there a cheat way to pre-fill the formula so as i make a new sheet for each player, i do not need update each formula to find the data from the player sheet.

Let me know if this does not make sense