compare tables and extract data matching a condition into a new worksheet

[maxnet24]

Compare Two Excel tables in a worrkbook on two seperate worksheets within the workbook and extract the data from both tables into a new worksheet for a matching filter

Table 1 has the following fields
Position
Job Location
Description
Company


Table 2 has the following fields
First Name
Last name
Email
company
Phone
Location


need to create a Table 3 where we get the rows data for following fields where companies Match in table 1 and 2 - since the companies names and spellings may differ due to Human error we need to do the match where the company names sound Similar

Position
Job Location
Description
Company
First Name
Last name
Email
company
Phone
Location