macro for searching multiple options with in workbook

Hello Friends
I want help in creating macro for the following.
I daily get a work of making this report for which I run a process through a specific software which creates this four files on server
1. India
2. USA
3. 2Wheeler
4. 4Wheeler
My work is to create a new excel file copy Sales person names from India & USA one below the other,
Then search the respective model sold by them in 2wheeler.
If any salesperson has sold 4wheeler we do not copy and data from 2wheller(sheet) we search it in 4 wheeler(Sheet) and copy data from that for example in the attach file
Raj has sold 1pulsar & 2, 4 Wheelers Therefore I didn’t took any data from 2wheeler I just search and copied model from 4wheeler
Same way I have done with Amol, Joy & Francis
I know this is very tough but it is not impossible hope I will get my solution so that it will save a lot of time for me