league table from multiple sheets

[daniel.thomas10]

Ok so the boss asks me to put a leage table together using the data from one sheet, did that for him but now he has asked me to do it again, But this time Im lost let me explain.

the first time i did it, The data sheet had just collum of figs to move on to the league table from just one sheet... it was this ONE data sheet that was updated.

now this one needs me to collect data from one collum but many sheets and keep an running total......

im stumped. Dont have a clue. Lost.... baffled.


No I have attached the sheet and league table..... the names are out of date due to a massve team change.

but in short collum C needs to pull the names G the HD number H the email I the RSG % and J the sales numbers

and this needs to be done on many sheets and updated

I have no idea how

ANY one?

[shg]

The organization of the data makes analysis needlessly difficult.

You could put all of the input data on a single sheet with a column for date, name, and each other field, and then use a pivot table.