Is this possible.. I am stumped!

[gcross4]

I am looking for some help with a workbook at work to save me a lot of time while executing one of my validations. The end goal is to have a few macros, or one large one, if possible, to run and set me up for my validations. I am looking to be able to run a macro that will copy the data from column B to sheet 2. Then, insert a given number of blank rows (10,20,50, or 100) between each piece of data. Then, create a hyperlink for the location of each piece of data from sheet 2 and place the hyperlink onto sheet 1 in Column C next to the corresponding data in Column B. Is this possible, any feedback would be awesome. Thanks in advance.