Compile summary with multiple sheets under conditions

[nikenis]

Hi All,

Sheet: Staff
Record staff details (ID, Name, Position....)
Sheet: Master
Sheet to be copied to new staff added
Sheet: Summary
Recap to show all staff attendance per month

Existing Macros:
-to add new sheet when a new employee is created
-to create an hyperlink from ID index to display the attendance sheet.

I am looking for a macro to pull info into Summary from all individual sheets. These info need to be filtered by month and positions

Regards