Moving row from multiple table to another table

[Seldrich]

Hello,
I have been trying for hours and am unable to find a solution.

Problem: Move row data from multiple tables to 1 table based on the the the cell value in that row.

The data:

Table Name: Mr. Big Stuff

EMP ID	AGENT	SUPERVISOR	STATUS	ADH
00000000	John Doe	Mr. Big Stuff	Billing	86.1
00000000	Jane Doe	Mr. Big Stuff	Billing	86.1
00000000	John Doe	Mr. Big Stuff	Billing	89.9
00000000	Jane Doe	Mr. Big Stuff	Billing	91.1
00000000	John Doe	Mr. Big Stuff	Billing	93.1

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Table Name: Mrs. Boss Lady

EMP ID	AGENT	SUPERVISOR	STATUS	ADH
00000000	John Doe	Mrs. Boss Lady	Billing	87.3
00000000	Jane Doe	Mrs. Boss Lady	Billing	90.5
00000000	John Doe	Mrs. Boss Lady	Billing	90.8
00000000	Jane Doe	Mrs. Boss Lady	Billing	90.9
00000000	John Doe	Mrs. Boss Lady	Billing	91.7

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

If the Cell in ADH is Less than 90.0 I need to move the row to the output table.in the same order as the information. In addition to that i need to add the same data from another table with the same format below the information from the previous table. Like below.

Table Name: Outliers

EMP ID	AGENT	SUPERVISOR	STATUS	ADH
00000000	John Doe	Mr. Big Stuff	Billing	86.1
00000000	Jane Doe	Mr. Big Stuff	Billing	86.1
00000000	John Doe	Mr. Big Stuff	Billing	89.9
00000000	John Doe	Mrs. Boss Lady	Billing	87.3

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

The information does change but it does not change format. All columns are the labeled the same and do not change. when the data is updated i need it to replace what is there with new data.


I have tried to =Index as well as =vlookup but have been unable to find a successful route of doing this. I am quite new to excel and have been stuck on this for a couple of days. thanks for any help and advice in advance!