Making automatic information chart

Hi, I have 300 employee info in a excel sheet with all details like name, designation, section, id, mobile, email, join date, date of birth, retirement date, present address, hometown etc.
Now, I want to make another few chart like- 1 chart with name, designation and mobile only. another 1 is with name, designation and blood group, another chart with name, designation, join date and section wise to send it to different section with different serial number

Another problem, I want - when i delete an employee from main list other list will update it automatically and put automatic serial no.

I tried, vlookup and pivot table but i couldn?t make it. Can anyone plz find me a way to easily to make it up.

You can achieve that with either PivotTable or Power Query.