I am trying to create a master pivot table from the data from different worksheets. I have 4 columns of data. Item, serial rcvd, serial shipped and RSA. I would like the mater pivot table to show in the row fields, Item number then RSA and in the data fields, show count of serial rcvd and serial shipped. When I use the ALT+D+P short cut, I get a pivot table but I can't get the format correct. Is there a way to create a macro to pull the data from multiple sheet and then create a single pivot table?