is this pivot table possible?

Hi
I have attached a file. in the sheet named "main" I have data. I make manually sheet "Door Count". Now I want a pivot table which will create sheet 'Door Count' style presentation from sheet 'main' data. is it possible.
if possible then plz give me suggestion. Or correct the file so that I can understand. Thank u