Besides that I suggest that the section to check if a pivot table exists be a little more sophisticated and at the same time define the source table's range, I noticed that a range was defined but it does not cover the entire table in Sheet 1
and misses the last column while the pivot table in Sheet 2 DOES cover the area.

Before you try to make the macro 'multi' useful I suggest that all parameters be written independent of the table name and pivot table name, it's a question of adding error traps to verify what exists and what doesn't so ou can be sure that the data represented is actually the data available.

If you define a source that only applies from row 1 through row 26 but the data goes on to row 39, you're seriously missing 13 rows of data
Back to the drawing table and think it over.