Macro help needed to collate data from one worksheet into a second worksheet

[Pearl18]

Hi
I am very new to VBA programming. I'm trying to collate data that is populated in one worksheet and save only certain columns from that worksheet into a new ever evolving worksheet. Is this possible through the use of a macro?
The original worksheet will have data populated from various sources it is the culmination of that data I want to record on the second worksheet. Is there a way of doing this so that the second worksheet is always current with data that has been added to the first worksheet?

Apologies if I have not explained myself clearly.

Edit

the original worksheet will need data sorted and the results of the sort are what populates the second worksheet. Are these actions I can write a macro for?