Specific rows from multiple sheets compiled consecutively into another sheet

[rajmathew]

Hello Everyone,

So here's my problem. I am trying to create an order form in one sheet of a workbook based off of selected items in lists found in other sheets in the same workbook.

So, in this particular workbook, I have a large list of products that I am selling that I have listed on different sheets based on their type (sheets B through E). In the cells to the right of each product are their descriptions and prices. There is a blank column to the left of the product lists on each of the sheets.

I would like a customer to be able to put an x into the cell to the left of the product they would like to buy. I would like excel to take all the products in all the sheets (including the descriptions and prices beside them) that have x's beside them, and populate them consecutively in one final sheet (order sheet).

Possible? Is there a better way of accomplishing what I am after or a cleaner more streamlined way?

Thanks,

Raj

ps, I tried to attach a file but it won't let me for some reason, sorry about that.

[MarvinP]

Hi Raj,

I believe this is a snap using Power Query. You would append all sheets into a single sheet and filter out all rows that don't have an X in them. Time to learn Power Query??

https://www.excelguru.ca/blog/2014/1...g-power-query/ or
http://radacad.com/append-vs-merge-i...nd-power-query