VBA Help - Find 38 unique values (accounts) across all worksheets & display entire row

This one is quite complicated. I'm new here so go easy on me:

I get a daily report for all our accounts with outstanding balances. There's about 3,500 accounts. When I download the report to Excel it puts 103 accounts on a worksheet, so there's usually 34 or 35 worksheets.

I need a macro that displays only these 38 accounts and ideally would display the entire row for each account:

30783819
30863296
30867342
30898966
30769419
30747148
30731023
30731226
30731234
30747623
30769857
30827826
30770364
30770436
30770508
30770516
30770524
30770575
30783878
30804392
30792459
30805061
30805088
30805205
30827711
30846701
30856782
30872555
30872563
30872571
30866374
30834647
30877364
30872205
30877073
30877188
30878236
30877356

I would need to do this every day. The file name is different each day. If anyone could help I would greatly appreciate it. Would save me a lot of time each day! Thanks!

It worked for the sample, but when I applied it to the actual workbook I'm using it did not work. I deleted a few columns. Didn't think it would matter. I will upload the actual workbook with most of the worksheets deleted. Could you take a look at it again? Thanks so much for your time and effort.

Nevermind. I just changed the range and it worked beautifully. Thank you so much!

Do you know if there's a way to display the headers as well?