Search mutli sheets and capture

Hi There All Gurus

I need Help - I have created a mess and had to start from scratch and need your help.

I have to assemble a Asset Register per Department with the last service date and the Next service date. I want to create a VBA to search all the sheets (Tabs) and retrieve all the equipment which has to be serviced on the month I select in the "Monthly service" Tab.

Please see the attachment.

I hope someone can help me

Much appreciated