Merging Mutiple Sheets column data when if conditions passes [Closed]


I have excel book with multiple sheets.

Rows count with data will differ in each sheets.

And column C with have two data "Come" & "Out"

What I want is, from each sheet, when cell value of column C is "Out" then the adjacent cell value in column B needs to copied to Column A of main sheet called "Main".

And to make identification in the main sheet, Column B needs to have a data of a particular cell (Say it as "A3" of the respective sheets)

For example, If you have copied data to the main from Sheet1 at A1, A2, A3, A4, A5 then I want B1, B2, B3, B4, B5 should be same value of Cell "A3" of Sheet1

There may few sheets where I don't have "Out" in Column C, For that I don't require any details in main sheet.

And Since we have made unique identification of copied cells, I don't required any empty rows to be given in between the data copied from multiple sheets.

Hope you have understand my query.