A Mouthful of Data to Transpose

[namariegaudi]

I originally posted a thread in ExcelForum here, since then I've reformatted my tables not knowing the best order for a VBA expert to help. I can change the order of the columns as needed to help ease the pain.

OK, I have 3 sheets, each with it's unique set of data
- Sheet 1: OT's has Orders to build products, but can include up to 11 ingredients. I need to transpose the data from that sheet to a separate sheet called Output - OTs. I tried to put a nice example of how I need the data to look
- Sheet 2: Remisiones is the shipping slip that can contain up to 2 product orders. I need to transpose the relevant data to show as many rows and items described (see Output - Remisiones)
- Sheet 3: Salidas, this is a list of the actual inventory retrievals based on the shipping slips which can be of one product or a multiple set of them. If the retrieval is associated with one OT and that retrieval has 2 lots associated it can become a nasty long list of product, kilos, lots, liters etc. etc. same thing, Need to transpose the data as reflected in the Output - Salidas sheet

I have a sample file here I need help