find value in column A, paste corresponding Column B value to another sheet.

Hi I am really stuck on this problem and hope that someone here could help me out.

Sheet 1 has raw data like this:

Company Model Qty
A A1243 1
B B1231 2
C C1231 1
B B1123 1
B B1232 1


I have used a match formula before but the columns can contained hundreds of data depending on the imported csv file so I would like to use a macro

So if there is a macro that can:

1. Find company B and the heading Model.
2. Copy the corresponding values under the column with the heading "Model" to another sheet .

e.g. will be sorted to look like this:

Model Qty
B1231 2
B1123 1
B1232 1

(sometimes the imported file may have the heading Model in another column so i wanted a macro that would recognize the heading)

If there is another post that has already addressed this problem, please direct me there

Thank you very much