Excel Automation and Data Parsing Expert Needed

I require an experienced Excel professional to automate and populate a template using data from a source sheet. This is a complex task requiring direct extraction and parsing.

Key Requirements:
- Extract and transform data as per Trackmaster_Auto Template fields from the DRF Final sheet.
- Implement complex formulas and calculations during the data extraction.
- Ensure accuracy and efficiency in data handling.

Ideal Skills and Experience:
- Advanced Excel expertise
- Strong data parsing and automation skills
- Experience with complex formulas and data manipulation
- Attention to detail and reliability

Please refer to the attached Word files for detailed instructions on data sourcing.