VBA EXCEL code if and copy paste to end of column on another sheet

I'm trying to create a VBA code that performs three steps.

Find a value in a specific column (e.g. "A") of "sheet 2" and if that value is there, copy the next cell on it's right (column "B") and paste it on the first blank cell after the last value of an already specified column (e.g. "C") of the "sheet1". It's important to note that the values on the sheet2 can be more than one and I wish that the macro copies and pastes whenever it finds that value on column A because on the other hand the values on column B will be different.

Are you able to help me?

I would be very grateful.

Thanks.