Converting 1 set of columns to 2 sets or more: Example Attached

Hi, from the example below I would like to take the data from worksheet1 and put into worksheet2 but limit the length of a list (the real spread sheet has over 1000 rows and i would like them in 4 sets of 250 versus the example I provided). Is there an array or macro that would make this work (keeping the formatting)...I am not great with macros, so that approach might need a little explanation.