Request for Help on Pulling Data from Companies House Using SIC Codes

Hi All, I'd love to get the communities input. I am currently trying to pull data from companies house. Ideally I want to be able to find companies with specific SIC codes, pull them into a clay table and then analyse their latest accounts data for cash at bank and assets. Has anyone done this?