Constructing new table based on elements of a pre-existing table

[the number cruncher]

Hi,

I am having trouble working out how to construct a new table based on the elements of an existing table. I'm pretty sure it's a combination of VLOOKUP and MATCH but he could also use INDEX. Here is the master table:
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Date</th><th>Part No</th><th>Price</th><th>Engine 1</th><th>Engine 2</th><th>Engine 3</th></tr></thead><tbody>
<tr><td>22-Mar-17</td><td>Part 1</td><td>38.35</td><td>x</td><td>x</td><td> </td></tr>
<tr><td>12-Mar-17</td><td>Part 2</td><td>110.05</td><td> </td><td>x</td><td>x</td></tr>
<tr><td>10-Feb-17</td><td>Part 1</td><td>163.95</td><td>x</td><td> </td><td>x</td></tr>
<tr><td>6-Feb-17</td><td>Part 3</td><td>6.69</td><td> </td><td>x</td><td></td></tr>
</tbody></table>
Assume here that the date column is in column A, part number column B. etc and data starts in Row 2
I wish to construct three new tables for Engine 1, Engine 2 and Engine 3 based on the indicator 'x'. The result of the 3 new tables would look like:
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Engine1</th><th> </th><th> </th></tr></thead><tbody>
<tr><td>Date</td><td>Part No</td><td>Price</td></tr>
<tr><td>22-Mar-17</td><td>Vendor 1</td><td>38.35</td></tr>
<tr><td>10-Feb-17</td><td>Vendor 1</td><td>163.95</td></tr>
</tbody></table>
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Engine 2</th><th> </th><th> </th></tr></thead><tbody>
<tr><td>Date</td><td>Part No</td><td>Price</td></tr>
<tr><td>22-Mar-17</td><td>Vendor 1</td><td>38.35</td></tr>
<tr><td>12-Mar-17</td><td>Vendor 2</td><td>110.05</td></tr>
<tr><td>6-Feb-17</td><td>Part 3</td><td>6.69</td></tr>
</tbody></table>

<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Engine 3</th><th> </th><th> </th></tr></thead><tbody>
<tr><td>Date</td><td>Part No</td><td>Price</td></tr>
<tr><td>12-Mar-17</td><td>Part 2</td><td>110.05</td></tr>
<tr><td>10-Feb-17</td><td>Part 1</td><td>163.95</td></tr>
</tbody></table>

These tables can be on separate worksheets, or elsewhere in the spreadsheet, but for simplicity assume that each one is on a new worksheet and starts at cell A1.

Any help is appreciated.

Thanks