Excel Formula Creation for Data Retrieval

I'm in need of an Excel expert who can create a formula for me to match multiple criteria across several sheets in a workbook. The criteria involve both text and numerical values.

Key requirements for the task:
- The formula should be able to match text values and numerical values
- The formula should retrieve specific data based on the matched criteria
- The data retrieval should be from multiple sheets in the same workbook

Ideal skills for this project:
- Proficiency in Excel
- Experience with formula creation
- Understanding of data retrieval techniques in Excel