Excel Macro for Data Summary

I need a macro to prepare a summary in Excel using data from two different sheets. The macro should apply necessary logics and filters to organize the data efficiently.

Ideal Skills and Experience:
- Proficiency in Excel, especially in writing and implementing macros
- Experience with data manipulation and summarization
- Familiarity with customer data management
- Attention to detail and accuracy

Please provide examples of similar work done.