How to Export Dataframes to Excel Workbook as Sheets with For Loop

I've written a code that runs through a for loop to generate data into dataframes but I want to export this data to a single workbook rather than multiple workbooks (actual code is on work computer and work stuff is confidential so dummy code is below)

Below is a general idea of how the code runs without the actual details of how the dataframes are composed. (Dummy code is running on csv files I pulled off Yahoo Finance)

FileName_List = ["AAPL", "GME", "MSFT", "NTDOY", "Z"]

for FileName in FileName_List:
    ReadName = FileName + ".csv"
    Raw_Data = pd.read_csv(ReadName, sep = ",")
  
    # removed code that actually manipulates data as it's not needed for example purposes and alludes to confidential data

    Raw_Data.to_excel("Final_Output.xlsx", sheet_name = FileName)

So now my directory has a bunch of Excel. I could manually just move them all into a single work book but with the actual amount of files I'll be running through, it would be just a time waste to do that.

I would want the end of my code to run everything to the same workbook and each sheet named with the for loop

The files land as is in separate files, so I can't change how the files hit. Again the above sample code is not actually the real number of files this code will have to run though

I've also tried using ExcelWriter but after the first loop it errors ask asking for a zipfile format using example code I found here: https://www.statology.org/write-multiple-excel-sheets-pandas/

The DataFrame.to_excel() says the following when wanting to create more that one sheet in a workbook:

> If you wish to write to more than one sheet in the workbook, it is
> necessary to specify an ExcelWriter object:
>
> df2 = df1.copy()
> with pd.ExcelWriter('output.xlsx') as writer:
> df1.to_excel(writer, sheet_name='Sheet_name_1')
> df2.to_excel(writer, sheet_name='Sheet_name_2')

So taking the code mentioned above and applying it to your code it would like this:

FileName_List = ["AAPL", "GME", "MSFT", "NTDOY", "Z"]
# Create ExcelWriter object
df_list = []
for FileName in FileName_List:
    ReadName = FileName + ".csv"
    Raw_Data = pd.read_csv(ReadName, sep = ",")


    # PRETEND THAT THERE'S CODE HERE THAT ACTUALLY MANIPULATES THE DATA
    # Append to df list
    df_list.append(Raw_Data)

with pd.ExcelWriter('Final_Output.xlsx') as writer:
    for FileName, df in zip(FileName_List, df_list):
        # Write to excel sheet with writer object
        df.to_excel(writer, sheet_name=FileName)

Note: you want to manipulate your dataframes first and append them into a list. Once that is done, you want to write them into a excel workbook in one go as multiple worksheets.