IFERROR from multiple tables/sheets - Follow up to my old post

Hi,

I posted a question that was answered by awesome /u/nflsales. Forum thread here: http://goo.gl/rNz306

The problem was: So the general idea is I want to make some sort of a template for purchase orders(or invoices/or even quotes) where a list(report?) will be generated that will ONLY show the relevant products. What I want to work out is to have all my items listed in the first worksheet. I want the list/report in worksheet 2 to work so that I only need to write how much of an item I need in worksheet 1 and that will show on worksheet 2.

This was answered by /u/nflsales with:

=IFERROR(INDEX('Products List'!A:A,SMALL(INDEX(('Products List'!$A$2:$A$100="")*10^10+ROW('Products List'!$A$2:$A$100),0),ROW($A1))),"")

which worked amazingly!

Now I have a follow up question.

What if I have my products across multiple tables - like the attached file, how would you approach the problem? Let's say I have a LOT of products and have them divided into categories across multiple tables in a sheet so I don't need to scroll so much for an item.

Thanks in advanced!