excel macro to extract first three rows of excel files from a folder and create new file

Hi to all VBA Programmers,

I have some excel files having data and all the files have same column names like this.

Individuals color Rank
1 red 1
2 blue 2
3 green 3
4 yellow 4
5 orange 5
6 blue 6
7 green 7
8 orange 8
9 yellow 9
10 green 10

Now I want to extract top three individuals from all the files in a folders based on Rank column (Basically selecting top rank Individuals) and I want to create separate new file with all the selected top three individual lists. Is it possibile to do with macro? because doing it manually taking so much time to achving my target for doing more than 150 files. I need help to solve this problem. Any help would be highly aprreciated. please see the attched example file for better understanding and sheet what and how i am expecting.
Thanks in advance,

Regards,
Genetist