I have sheets 1, 2 & 3.

Sheet 1 has a column of values, e.g. C123, D2333, C4500 etc. They are all excel cell coordinates.

Sheet 2 is rows of data.

How can I match the column of data in sheet 1 (cell values) with their rows in sheet 2 and copy all matching rows into a empty new 3rd sheet?