Multi page order sheet with summary page

First post.

I have an order form with 22 sheets and one summary sheet.
What I would like to have happen is that customers fill in order quantities on each of the sheets, then have any rows that have an order quantity copy automatically onto the summary sheet. This way the person ordering can go to specific sheets for the category of product they are wanting to order and the person inputting the order will only have one sheet to input from.

not sure if this is easy , hard or impossible. Hoping and advanced user can help a novice out.

Hi Dsmith22,

Welcome to Excel Forum.

What is the total number of items on all 22 sheets?
I'm thimking along the lines of using VLOOKUPS.

Regards

peterrc

Hello Oeldere,

Each of the sheets has one department in it. Examples: Fir lumber, Pressure Treated Lumber, Cedar, Cement products. Some of the sheets have over 100 rows. When combined into one sheet, it becomes difficult to look through. I want to make it as simple as possible for the store to place orders. If they only need cement products and plywoods then they look at those tabs only and fill in their order quantities.
But when the file is sent to the order entry person, I would like them to look at only one sheet with all of the ordered product only on it. I don't want them to have to look in all of the sheets to see if there are order quantities in them.

If I could figure out the attachment function , I would put the file up for you to look at. LOL

I'm hoping the file is now attached

You are correct. Sorry, new to this.

I've manually filled a sample one in.

I've ordered product from the Fir sheet, the Flashings sheet and the roofing sheet.

and the Summary sheet shows what I'd like to achieve.

I hope this clarifies the challenge.

Hello Oeldere,

I was not able to open your sample sheet. Came up with an error message (attached)