Copy Data from multiple sheets to one sheet based on condition

[MacroNovice0309]

Hi, I am a complete novice to vba and looking for help here. I need to copy data from a specific column 'Name' on multiple sheets in to one sheet based on criteria -

The criteria is -

• Filter on column 'Contractor' as No
• find column which has column name containing current month
• Check the values in the column between 1 and Null
• for all 1's found, select the values from corresponding column B
• copy the data in to a new sheet () that is reset each time the macro is run.

I am absolute novice with VBA and cant seem to find anything on google that can help with this. Hoping someone here could help.

Thanks in advance !