Excel Pivot Table Automation

I keep two separate price lists in Excel and enter every line manually. What I need is an easy-to-maintain workbook where those two lists are stored as structured Tables and automatically feed a single PivotTable that shows:

• each licence plate only once
• the summed total for that plate
• the associated company name(s)
• the relevant date information I type in with each record

All data is keyed in by hand and I update the lists roughly once a month, so the solution must cope smoothly with new rows pasted or typed at the bottom—no editing of ranges every time. A one-click (or automatic) refresh will be perfect.

You are free to build this with native Excel Tables, Power Query, simple VBA, or any mix that keeps everything inside one .xlsx/.xlsm file and remains user-friendly for a non-technical person. Final delivery includes:

– the finished workbook with both source Tables and the dynamic Pivot
– a brief note (or short video/gif) showing how I add data and refresh the results

If I can open the file, type in new rows, hit Refresh, and instantly see the updated Pivot exactly as described, the job is done.