How can I write this function on VBA- Excel 2003?

I have a range of cells that I add data to on a weekly basis. At the end of the week, I cut this range and paste it in another sheet within the same file. The trick is that I have to paste it in the reverse order. So, cells from B--> H needs to be pasted in the reverse direction H-->B. How can I do this using VBA?