Pulling row data by cell text

I am looking to pull data to a new worksheet by name and following data in that row. For example

In the new worksheet I want pull all sales date for customer named "ABC".

In the old or original worksheek ABC is: Column A is Customer Name ("ABC"), Column B is units sold, and Column C is dollar sales.

On the new worksheet can I put a formula to pull all ABC data in column B and C? Keep in mind the new sheet will not be organized the same way as the old worksheet ie... Customer ABC will not be in the same cronilogical order so I can not simpily =oldsheetA3


Thanks

Liam

a2 : ABC

B2: INDEX(oldsheet!$b$2:$C$5000,match($a2,oldsheet!$a$2:$a$5000,0),match(b$1,oldsheet!$b$1:$c$1,0))

copy formula over and down as needed

This will look up A2 in the the first column of oldsheet to match the row, lookup the header in B1/C1 to match the column, and pull whatever lines up in the table on the first page.