Dynamic table in a different sheet from multiple tables in other sheet

Hello

I have attached a well worked example.

I am trying to compile the results of many tables (only 3 in the example) from 3 different fish supply companies (3 separate work sheets) and compile these into 1 table in another sheet. Each of the sources tables are 35 rows deep and have a PO (Purchase Order) against each row. The row for each PO which extends horizontally by month date, may or may not contain a characteristic (eg ADV, PAC, FAC). Characteristics for PO No's will be entered into the table not in any particular order. Therefore the characteristics may be distributed across different PO's for each of the different fish suppliers.

Each of the supplier tables is 35 rows deep.

The Result Data for populated PO's in the different supplier tables (different sheets) need to be aggregated in the table in Result Data. If there is no data in the row for a particular PO for a particular Fish Supplier, then that PO is NOT included in the Result Data table. Therefore the maximum depth of the table might be 3x35, or the minimum being zero (0). For each row that is returned, the relevant descriptors (Supplier, Payment, etc) from column D-H are returned.

The PO numbers contained in each of the supplier tables may not be entered from lowest to highest. Some PO's might in fact be entered in an alpha-numeric code. And in some instances the descriptors in Column D-H might be blank (except PO) in which case a blank needs to be returned into Result Data.

Note - this is an example. There are in fact more suppliers than three so I will need to be able to add tables (i.,e new sheets) and make the compiled Data Result bigger.

If anyone can crack this for me, I will bestow legend status on you))))

Thanks in advance

david