VBA - Find multiple cell and copy offset

[Atik]

I have a sheet which contain a lot of data. Among them I want to find all cell which value is "atik" copy the cell value before "atik" and paste in second sheet in one column with the column heading atik. If a cell copied from row 1. It should be placed in row two as row 1 of the column contain heading atik. If find two file in same row 4. then both the value will be placed in the next sheet row 5. which column atik. two value need to separated by comma. or sum of two value.

Please see my attach file to understood my requirement.Book1.xlsx

[sktneer]

Please find the attached sheet and click on the Yellow Button on the sheet to get the desired output on Output Sheet.

[Atik]

Thank you very much sir, It's just awesome. like this.

[sktneer]

You're welcome Atik. Glad I could help.