Loop to save all versions of report using drop down

Hi and welcome to the forum.

1.) You need to edit your post and add CODE tags around your VBA code. It's a forum rule, and others are adamant about enforcing it.

2.) "My current Marco is causing the saved files to crash excel"
Can you better explain exactly what happens? It can help diagnose the issue. If the code errors, what is the error description and what line of code is highlighted when you click the Debug button on the error dialog?

3.) Delete the two Call commands.

With newWks
Call .Cells.Copy
Call .Range("a1").PasteSpecial(Paste:=xlValues)
End With