Summarising data using combo box

Hello,

I reeealy need help

I have about 44 sheets of data which show information about different products from manufacturers (1 sheet=one manufacturer). Every sheet has the same number of columns (the same info about the every product), but different number of rows (one manufacturer has more products to offer than the other one). I wish to make a summary sheet, where by using the combo box (from which you would pick a manufacturer), the data about that manufacturer would be shown. Is this even possible?

Thanx a lot in advance!

P.S. I have attached an example with just 3 sheets