macro - pivot table

[eran3185]

hi
I have a file that contain some worksheets . in every worksheet , I build a pivot table that contain columns a-c .
I want to do pivot table in every worksheet (that take a relevant cells).
I have a macro but I don?t know how to get a relevant cells in every worksheet