Create Pivottable macro

Hi I recorded a macro which i need to run on various sheets to create a pivot table - obviously the data range changes with each sheet this is where my macro is breaking down, below is the code used to create it on one sheet however i need this to be dynamic not based on sheet name - activesheet is fine just not sure how to amoned the code

Please Login or Register  to view this content.

i highlighted the area i think is the problem

tia