Creating new Pivot table with dynamic sheet names/ranges

I'm trying to create a pivot table on a new sheet with dynamic sheet names/ranges and I keep getting error "Invalid procedure call or argument" error. My code is below:

Please Login or Register  to view this content.

Just for comparison sake, code when copied straight from the from macro:

Please Login or Register  to view this content.

All I've done is replace the static ranges with dynamic ones. Why isn't this working? Any help is appreciated!