Auto fill text using formula or code

[nicmarty]

I am looking for a formula or code that will take information from Sheet1 and on Sheet2 it will copy down each column and duplicate each row based on the value in Column I. So for instance, Row 1 will duplicate 5 times before moving on to the next row which will only be listed once on sheet 2. I have filled in on Sheet 2 what I would like it to look like. Thanks in advance