Google Sheet Automation

I need a Google Sheet that I can populate with mixed data (text and numeric) and that will automatically populate 1-3 other Google Sheets. The data in the initial Google Sheet should be organized in a mix of both rows and columns.

Ideal skills and experience:
- Proficiency in Google Sheets
- Experience with Google Sheets automation and linking
- Knowledge of formulas and data organization