I'm hoping someone can point me in the right direction.

I'm trying to create a worksheet that totals values from other worksheets.


Specifically its a lineup sheet for little league baseball.
I'm trying to get the kids to all the positions in the field and the batting
order.

My lineup looks like innings across the top and players name up and down in
the
left column. I insert the position they play for each inning.

I would like my master sheet to have the players names follow up and down
and the positions across the top with how many innings they have played for
the data.


Hope this doesn't sound to convoluted.
I'm not sure where to start with this one.


thanks
robert