Can't create a Master Pivot table from multiple worksheets in the same workbook

I am trying to create a macro that would create a pivot table from the data from different worksheets. I tried creating a pivot table using the "ALT+D+P" wizard but I can't get the pivot table formatted that way I would like to. Is there a way to create a macro that would create a master pivot table using the data from the worksheets in this workbook and in the same format as the pivot tables on the individual worksheets? Look forward to your assistance. I have attached the sample workbook I have been using for all my my testing and creating macros.

Thanks!