Extracting Data from multiple sheets to one sheet based on criteria

[ssincerely]

Good Day Excelites,
I have a workbook with multiple sheets all identical. In different cells there are, name, age, address, occupation, date reporting etal. I want to extract from each sheet the name, age, occupation and address based on date reported with the criteria within the 7 days..... Formula or vba would do fine.

Thanks in advance.

 

[Macropod]

Cross-posted at: https://www.excelguru.ca/forums/sho...-multiple-sheets-to-another-based-on-criteria
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html