Web Directory Address Scraping - Excel

We have one web business directory we need to grab as MANY RECORDS AS POSSIBLE within certain parent categories and create excel files with these. The address to this website will be provided through PMB. We are interested mainly in execution and accuracy of records, we will cross check records randomly. There will be a couple of parameters that will be used to determine if we are scraping the record or not, example of one could be address with no postal code and or incomplete. The person doing this job should know how to web scrape a directory including going into sub-categories with code. There will be categories within web directory that will have thousand plus records, you'll need to be able to iterate through pages and extract records which match conditions.