Display data from two tables in one on a different sheet.

[Lotrking1010]

Hello,

I have a workbook that is going to be used to store BoM information. The workbook I have has two sheets; the first should only display relevant information to build the product in on simple table (Table A), the second to store all the relevant information including prices and various other information. The problem is on the second sheet I have two different tables on for expensive parts that are ordered as needed (Table B) and another for consumable parts that are always kept in stock (Table C). One table will have all the information entered manually and the other will pull for a database of all our stocked parts with only the PN and QTY being entered. I need to display all the data from Table B and Table C in Table A on the first sheet. The problem is that I need to read from Table B until I hit blank cells then read the data from Table C. Is there a formula that will do this? The size of Tables B and C will vary from one product to the other and I need it all to show on Table A without any blanks in the middle of the Table.




Example.xlsx