PivotTable keeps adding additional columns on macro run

I am struggling with trying to figure out why a simple macro that deletes a data sheet and imports a new data sheet (same amount of columns, but could have new rows) is not having an existing Pivot Table update on those values. (either automatically or by refresh option). The reason it cannot refresh is the DATA SOURCE keeps adding additional columns that do not have any data, i.e. instead of stopping on column R, is will stop on column S, or Y, etc.

The last part of the macro relies on the auto-update of the Pivot, so the entire project is at a stall, why?????!