Create Macro to copy X marked lines in 39 other Sheets to the First Sheet by order

Even though I know how to use excel to some extent, programming surpasses my capabilities. And that includes Macro creation .

All I want to do is have an excel file with 40 Spreadsheets, being that 39 of them are for apartments faults, and the first one is for a resume of all the faults still occurring in all the apartments.

So my idea was to have a column dedicated in each of the apartment Spreadsheets to be assign with an X, and then a macro on the first one that would check all of them and copy by order from all X marked Lines to the first one with all the information.

I hope this is possible to do, please give me a hand here .

Thank you in advance

I forgot something, can the macro update button delete everything in the first sheet and update it from all the other spreadsheets every time?? As this is going to be updated on a daily basis, it is better to avoid duplicates, and keep the unresolved fault spreadsheet up to date with no copies or duplicates.

Thank you very much for your help