I have 10 columns "column 1" .. "column 10" from left to right in a
source sheet. I want to copy them to another sheet such that the
columns are now ordered "column 10" .. "column 1" from left to right.

It feels like this should be very easy to do; but for some reason I
have not managed to figure out the solution. Can someone point me in
the right direction?