DATA COLLECTION

I need to make 2 separate Xcel file lists that can be used as a main database to email from. I will supply the initial file lists that already have data provided for you to work from One being a suppliers list, that has: No duplicates Company name web address phone email First name - (if possible) Last name - (if possible) The second list is called a Architect list, that needs: No duplicates Company name email address First name Last name And state, ie Australia has 7 states - NSW/ACT/VIC/WA/NT/QLD/ACT/TAS I will supply the current list the for the information for the 'SUPPLIER LIST' list. The remaining names need to be collected from these 2 sites [login to view URL] Need the following fields in Xcel sheet Company name/phone/email address/ contact name (if possible) [login to view URL] Need the following fields in Xcel sheet Company name/phone/email address/ contact name (if possible) I will supply the current list the for the information for the 'ARCHITECT LIST' list. The remaining names need to be collected from these 2 sites Need the following fields in Xcel sheet; Broken into states. wa/nt/qld/nsw/vic/sa/act Company name/ phone/email/ first name/last name [login to view URL] [login to view URL] [login to view URL] [login to view URL] Breakdown into states Breakdown into industry segments Architects Interior Design Landscaping