How to populate a sheet with specific data from other sheets?

Question

Macros

There is Sheet 1, Sheet 2, Sheet 3, Sheet CLEANING. Only 4 sheets.

Data is entered manually in sheets 1-3.
task: to fill in the "CLEANING sheet" automatically. the formula or macro searches the "comments" columns for the word "cleaning" and fills in the rows in the "CLEANING SHEET" by copying the data from the cells plus the sheet name.

Please teach me how to write such a macro.