(VBA_Need to pick data with multiple criteria without duplicating it

[forginganewone]

Result : The result going in a new sheet.
Criteria : only two criteria from A2 and G2. H2 is sheet name from which data will be searched and F2 is number of rows which should be picked.
Searching : I will be searching in a sheet with multiple columns. The column of A2 and G2 will be same in that sheet but other coulmns data will be different, so i want a script of formula to search and pick number of rows(F2) on criteria A2 and G2 but do not duplicate the rows.
For example value in F2 is 3, the script/forumla will pick 3 unique rows from sheet(H2) on criteria A2 and G2

Please find sample data here
https://expirebox.com/download/edf2c...b03667b11.html

Breakup sheet : from where formula will take criteria from
Cables sheet : from where it will search data
Results sheet : Where output should be given

Please note that i want the script to populate all the results of data in breakup sheet.

 

[forginganewone]

bump

 

[forginganewone]

Further clarification:

If 'cables!A:A'='breakup!G:G' & 'cables!D:D'='break!A:A' then copy number of rows(given in 'breakup'g:g') to results sheet. It should not duplicate data and pick unique rows as other columns data will be unique in cables sheet for example asset codes and serial numbers.

the cables sheet is where it picks relevant data from, to use it in formula it should take it from 'breakup!H:H' column.

Please look at file : https://expirebox.com/download/edf2c...b03667b11.html for example.