Open only data to first sheet

[Hangenniu]

Hi all,

I'm trying to have a macro that will copy the whole row containing "open" on sheets 2 onwards into sheet 1(MASTER). also, is it possible for it to be not case sensitive? meaning as long as it contains the word "open", it will copy the whole row into sheet 1.

The restriction i have is i cant use any excel add-ins or other programs because im using a company laptop and i dont have administrator access.

Thank you all in advance.

Kindest regards,
Niu