I have a large log of requests from various companies with details for each request. The only unique values are request numbers. Is there a way to make a report with only entries for a certain company? I'm having to filter, copy and paste information into another sheet every morning for each company showing only certain columns of information and I'm wondering if there's an easier way to do produce these reports.

Any advice would be appreciated!