Finding all Data with name and a y

[Mega1]

I have a sheet with data split into 52 weeks and there is totals on each line I want to be able to pick a company from c and from 0 "y" I want to get all where these are the same
on sheet2 I want each roe. this is so I can show what invoices have to be paid.

Thanks