I basically have an active Excel workbook that has 3 sheets in it and then 3 other excel workbooks that are open (each with just one sheet in them). When the macro runs I'd like it to take the 1st sheet from the active excel workbook and copy and paste it over to the 1st open workbook (replacing everything on the 1st sheet of that workbook) and take the 2nd sheet from the active excel workbook and copy and paste it over to the 2nd open workbook replacing everything on the 2nd sheet of that workbook and the same logic for the 3rd sheet and saves each of them as a csv (They're already in csv format).

Right now, I have a macro that can create three separate workbooks from the 3 sheets and then save it over the sheets but it's way too slow so thought a method to do this would be better but couldn't find the right solution anywhere.