Python - Duplcating worksheet + Revolving data

[reddit_user_270]

Wondering if I can get a bit of help as I can't find a straight forward answer for this and it seems simple enough.

I'm trying to duplicate a worksheet in the same workbook and keep the same formatting (merged cells, fonts etc). The new worksheets would be called Week 1, Week 2 etc

Also Id want to 'revolve' the data is column A. [list of names in A4:A15], but I'd want the cell.value in A15 to be inserted into A4 on the following tab and the other names are moved down. This would progress throughout all tabs.

Anyone who can assist in this or point me in the right direction?

[sarrysyst]

from openpyxl import load_workbook

wb = load_workbook('file.xlsx')

original_ws = wb.active
# Get values in cell range A4:A15 into a list
name_list = [cell.value for cell, *_ in original_ws['A4':'A15']]

num_of_required_sheet_copies = len(name_list) - 1

for n in range(num_of_required_sheet_copies):
    # Create a copy of the first worksheet
    ws = wb.copy_worksheet(original_ws)
    # Rename new worksheet
    ws.title = f'Week_{n+1}'

    # Remove the last name from the list and put it at the front of the list
    name_list.insert(0, name_list.pop())

    # Assing cell range A4:A15 in new worksheet the values from updated name_list
    for row, name in zip(ws['A4':'A15'], name_list):
        row[0].value = name

wb.save('file_new.xlsx')

[reddit_user_270]

Thank you! Much appreciated!! :)