I have a work sheet with range named cells. For example, sheet1_sales_cars.

I want to replicate/copy this sheet mutliple times. How can I also replicate/copy the range names without having to go into each new sheet and range naming each cell?

The only change I want to make after replicating/copying the range names in the new sheets is to search/replace "sheet1" in sheet1_sales_cars with "sheet2" and so on.

This is possible as I am copying/pasting the raw data into the same fixed location in the sheets. This all then flows into a master file for data overview.

Thanks.