One-Click Excel Renewal Filter

I keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click.

Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables.

Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of instructions so I can update the customer criteria or move the code to other files in the future.