Suggestions to "Pivot Table" list of data

Being very new to VBA, I am looking for the best method to "Pivot Table" a list of data for the following scenario

I have a table of data that will be appended daily with several columns of data (employee name, badge #, OT for the day (in hours)). I need a way at the end of the pay period to "pivot table" the data so I end up with a single entry list with each employee's total OT.

I could use a pivot table and try to find a way to export the varying data range each time or I have a formula which after sorting the list so similar names are continuous will give a total on the last line for the each employee. Then I would have to try to remove the empty lines to leave a single entry for each employee.

I am looking for the best way to handle this. This will be used by an very inexperienced Excel user and I would like to automate the process via button click.

Suggestions?

Thanks.

Hope everyone is staying safe.

I figured out how to handle this situation.
Thanks and stay safe.

Hi RonnG and welcome to the forum,

If you or the other users have a newer version of excel, it has made the Slicer Tool just for you. Search for "Excel Pivot Slicer" and watch a few of the videos. If you can't upgrade then VBA may be the way to go. It would be better to upgrade and get the tool with a newer version of Excel, in my humble opinion.