Main objective: Looking for macros (or other solutions) to be built to produce 3 separate summary reports from a single data file, plus data formatting/conversion into smaller queried data lists (approximately 40 lists, from 2 template styles, 20 lists each style), sorted in a specific way. Specific notes for each summary report and queried data lists provided below. Attached "Sample file for macros.xlsx" includes more detailed requirements, sample data, report templates, reference files, and sample list templates/structure.
Additional info : Looking for estimate of hours required for this project in respondent proposals and for a complete solution to be delivered by October 21. Also, I work on a Mac but can use a PC if need be—a cross-platform solution would be optimal. Willing to move to a Google solution if that makes more sense.
Budget is flexible—I'm not sure how many hours this project would require.