Sort Columns into a specific and predefined order

Hi,

Every week I receive a worksheet where the columns of data on the ‘Data’ worksheet are not in the order I would like them to be.

Can anyone please advise me of the VBA code required to sort the columns in the following order:-

'Period' 'Project number' 'Description' 'Projdef.' 'Prof.Ctr.' 'IC Project' 'Typ' 'Start pro.' 'End date'




Many thanks in advance for any assistance required

Regards

Rob