mass generate personalised excel price lists

Job ID: 30959707

Budget: $10 – $30 AUD

we have a master price list, with 5 tiers of pricing.
each client gets different parts of the range at different tiers

1) we can produce a structured excel list of every client and their applicable tiers
2) we can provide the price list with the 5 tiers

3) can you provide a macro to mass generate personalised excel price lists (each file named "Pricelist 2021 <Customer Name."

sample data attached