VBA macro to extract specific rows and paste them onto a new sheet

Hi all,

I am using Excel 2010. I have hundred of Excel worksheets where I need to extract certain specific rows and paste them onto a new worksheet. I am wondering if someone can help with a macro to perform this task rather than the tedious Copy/Paste procedure.
I am enclosing a copy of the worksheet (Sheet 1) and the final output as desired (Sheet 2). All the worksheets where I will need to run the macro are of the same format as the one enclosed (Sheet 1).

Thank you for looking into my problem!

EBA INTAKE 16 JULY.xlsx

Originally Posted by LaffyAffy13

Its a simple task if you have a specific criteria that is involved with every single row you wish to take out. I'm thinking I'll write some code that pulls out every line with a number value in column M, under the "Total Rate", excluding the last (Total) line. Would that work?

That sounds interesting. Grateful if you could give it a try!

Thanks a lot LaffyAffy13! I will most probably need a small modification to the code (if possible) to perform something specific to that sheet. I will get back to you later on that in this same thread! Thanks a lot again!