Need help setting up Pivots to analize data already entered.

Need help setting up Pivots with data already entered

I have a lot of data that I need combined in pivots to compare. I had help from someone here (I wish I could find them) who designed a table with prices, so when I enter the data, the price automatically shows in the column. I need to combine a years worth of data (I enter data for each month or a two month period) so I can analyze different prices. For example: Last year I had set prices for 17 different items. At the end of last year, I did "X" amount of items 1,2,3... Let's say item #5 was $40.00 and item 13 was $100. I first need to combine all the data in pivots and then I need a table where I can play around the figures to see what I could have made with the different prices. I'm sorry if I'm not explaining properly. I have all the data in separate sheets and I don't know how to combine them. I've attached a sample of the file I need work with.

The INPUT sheet tab is where I enter all my data. It has a table at the top right with all the figures.

The next tab is the PIVOT, which I don't know how to create.

The next tab is SUMMARY BY ITEM

The next tab is FINAL FORMAT, which I need to do for my current input data, so I can print it.

The final tab is the SUMMARY.

I also need help in formatting data for print. Someone set up a template from which I do all my work on. I need help in setting up where the pages automatically print with pivots of the data and a cover sheet that shows all the data from the main sheet. As it is now, it's just one long data sheet. I'm enclosing a previous data sheet with the "raw" data and then the formatted data for printing.

Thank you!

Marty