Consolidating data from multiple worksheets

I have 4 excel files with ticket data and each ticket can have multiple status type in document(confirmed, in progress, resolved, pending etc).
I need to fetch ticket numbers from each document only those with status as in progress and confirmed into one consolidated sheet.

Is it possible to do it through lookup function or any other function?