Copy and Transpose multiple times in a new worksheet

I deleted my previous thread as i believe it may have been to complicated. I have updated this one to make my request simpler. I am looking for a Macro that copies the 4 cells in the Pivot Tab below and transposes them into SheetII cell B2 Multiiple times.

So far i have a simple macro that transposes them once, but i need it to be updated to transpose the range multiple times right under each other

Please Login or Register  to view this content.

PIVOT Tab

A B C D

Desired Result on sheetII starting in cell B2
A
B
C
D
A
B
C
D
A
B
C
D

How about

Please Login or Register  to view this content.

This will copy the range 20 times

Or if you want to copy down to the last row in colA try

Please Login or Register  to view this content.

@Fluff thank you very much!
I actually ended up changing it slightly to base it upon column A. Similar to your second post. But this works perfectly. I have been struggling with this for 5+ hours so thank you!!

Please Login or Register  to view this content.

Glad to help & thanks for the feedback