Making a condensed table (details inside)

One table in Excel (let's call it Table A) lists of the largest 200 US cities. In another table (let's call it Table B), I have data of thousands of US cities and most cities are mentioned multiple times, and in some cases close to 30 times. Both tables, the city name is in a column. Table A has US city names in column B and Table B as US city names in column E. I would like to create a condensed table which takes Table B as a starting point and includes only the top 200 US cities and omits everything else. For added clarity, let's take NYC for an example. There are about 25 rows that mention NYC. I would like this query to see NYC in Table A and know that it should search the entire Table B and pull every row that includes NYC in the condensed table. It doesn't matter of this condensed table is in a new tab or not.

Thanks so much in advance

Thank you, PMFDibbins! I attached a file with sample data.

The attached file includes three tables. The first two tables are similar to the ones I'm working with.

The third table is what I'd like to get

Just to make clear - I like to look at the cities listed in Table 1 and search for all matches in Table 2.
It's common for multiple matches to occur for each city listed in Table 1.

The for each match, copy the entire row and paste it in the Output table. In the case of New York City, there are
multiple matches. Instead of just pasting the row where the first match exists, copy and paste all mentions of NYC to create a table.

Then it does the same for Los Angeles. It is possible for there to be no matches for a few cities listed in Table 1.

The main difference is that Table 2 is about 8 or 9 columns wide and probably about 10k-20k rows.

Please ask if you need clarity. Thanks a bunch!

You could add this formula to D3:

=IFERROR(INDEX(A:A,MATCH(E3,B:B,0)),"")

then copy it down to the bottom of Table 2. It will fill in the appropriate rank from column A. Then you can fix those formulae to values using Copy | Paste Special | Values | OK | Esc. Then you can sort Table 2 (including those ranks) using the new rank column as the sort field.

Hope this helps.

Pete

Thanks so much guys

Stupid question, how do I open up VBA editor? I don't think I've done this is some 10 years. I tried Alt & F11, but it opens up another worksheet. I figure I ask.

Thanks again.