Excel Macro - selecting,copying and pasting

Hello,

I am trying to find a code which will enable me to select, copy and paste specific cells.

I have a macro which will place an "X" in a cell after the user inputs this ultimately highlights the info the user wants. And I want to program the macro so that it can copy and paste any cells which are populated with "x" to another worksheet so it is consolidated. Because the "X" are dynamic i need a code which can do that

Any help greatly appreciated