I have a very important project for my company. My responsibility is to develop this product/spreadsheet with the following specifications. This is outside my Excel expertise. I need most efficient way, whether by calculations, IF statements or by Macros and VBA to do the following:
1. URL lookup and login to 3rd Party Web based Software
2. access my local Excel Spreadsheet data tab for single customer ID # per request. (Note: Multiple ID Query not possible into 3rd party software)
3. enter customer ID into 3rd party lookup data field
4. take 3rd party Export Report in Excel and extract specific data (text and numeric) which is random throughout the report and import / Map it back into My Excel Spreadsheet SAMPLE DATA.xlsxto specific columns for Statistical Analysis. The normal batch request for this data might be 500 to 1000 customer files. Each file may contain contain 400-800 cells of data.

Need Recommendation of what to use: Macro, VBA, calculation, etc..

See attached files for my spreasheet format and the export format of the 3rd party software.
1. Tab "My Company Export Data" is the input to the 3rd Party Web Based Program
2. Tab "3rd Party Export Data" is the import data to "My Company Import Data"
3. Tab "My Company Import Data" is the final spreadsheet format for statistical analysis