How to remove unwanted rows on multiple worksheets

Hello all,

I have a large spreadsheet with multiple worksheets.

The first worksheet contains a list of study numbers (patients), and some corresponding data in columns. The list of study numbers is not consecutive - there are quite a few patients who have been removed.

The subsequent worksheets have a consecutive list, and I want to remove the numbers that aren't in the first worksheet.

I have attached a small dummy file which may make it clearer! There are 2 worksheets in the dummy file.
Thanks,

Adrian