Hello, I have a recorded macro that automates a large amount of formatting for me from raw data report. In generating this formatted data from "Sheet1", it creates a new worksheet. This is generally named "Sheet2"

However, if I delete Sheet 1 and 2 and try to run it again on new raw data - i receive a global error from the macro.

Help?