Creating a Table

[jwgreen1986]

Wonder if anyone can help me. I am wanting to create a league table based on peoples sales. I am planning on separating the sales team into two worksheets. one for used one for new. the format below is what i will have on each worksheet. what i want to do is then create a separate worksheet with some drop downs on. the drop downs will have each of the month on. when the month is selected it will show a league table of the sales people with their sales for that month on it. sorted obviously so the person with the most is at the top.

how difficult is this to produce. i am more than happy to get the information i need into one organised spreadsheet. my issue is the creation of the drop downs and then it showing the correct information based on it. Also will i need to take into consideration if there are new starters. how would i make sure that drop downs will include new sales people in the tables. similarly i will need to hide, remove people if they have left (by their end date). so from below people like Bobby would only appear on the Jan table as he left the end of Jan, Emma wouldnt be on the Jan table because she didnt start till feb. and so on.

[TABLE="width: 500"]
<tbody>[TR]
[TD]User ID[/TD]
[TD]Name[/TD]
[TD]Site[/TD]
[TD]Scheme[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]YTD Sales[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]bobby[/TD]
[TD]luton[/TD]
[TD]New[/TD]
[TD]01/03/2018[/TD]
[TD]31/01/2019[/TD]
[TD]17[/TD]
[TD]17[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]465[/TD]
[TD]James[/TD]
[TD]Oldham[/TD]
[TD]Combined[/TD]
[TD]10/02/2016[/TD]
[TD][/TD]
[TD]26[/TD]
[TD]10[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]546[/TD]
[TD]Linda[/TD]
[TD]Derby[/TD]
[TD]New[/TD]
[TD]12/12/2012[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]468[/TD]
[TD]Emma[/TD]
[TD]Liverpool[/TD]
[TD]New[/TD]
[TD]01/02/2019[/TD]
[TD][/TD]
[TD]17[/TD]
[TD]0[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]454[/TD]
[TD]Carl[/TD]
[TD]Stoke[/TD]
[TD]Combined[/TD]
[TD]12/06/2017[/TD]
[TD]25/03/2019[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]987[/TD]
[TD]Mel[/TD]
[TD]Manchester[/TD]
[TD]New[/TD]
[TD]10/07/2017[/TD]
[TD][/TD]
[TD]31[/TD]
[TD]11[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]