Dragging down A B C D with the fill handle will not repeat the set.
You have to hold down CTRL and then drag the handle.
Sorting will change the references, unless you have
absolute references or values.
Another way is to use reverse Pivot Table. See
http://j-walk.com/ss/excel/usertips/tip068.htm
and sort by Column.