Auto Populate cell based on auto filter selection from table in same sheet

Hi,

I was just wondering if anybody can help me please?

I have a table which records children's attendance at a Before and After School club, which then allows me to then invoice parents for sessions attended.

I have tried to automate as much of this as possible, however the one thing I still have to do manually is update the child name based on the auto filter on the table.

Is there a way in which I can get excel to update a specific cell automatically, based on the choice I make on the auto filter?

I have added an extract from the table to hopefully assist in understanding

Example for help.xlsx

Thanks in advance