434547 Excel Macro to select copy and paste.

I have a column of either numbers or letters, (sheet1 column D) these could be as many as 4000 and could be anywhere in the sheet. My task is: 1) Look at the last two numbers, go on top of the column and search for where those two numbers first appear, then copy the whole column from there till down and paste it two columns to the right. Thus column G 2) You move further down the column searching for those two last numbers, when you find them you copy the column till down and paste it next the one you pasted before. Thus column H. You do this until you reach the last two digits. Sheet2 We check the last 3 numbers, and sheet3 we check the last 4 numbers! Thank you in advance.