Excel - A Macro to move data from rows to columns

Excel - A Macro to move data from rows to columns
Thanks to Venkat1926 for this tip!

This Macro is working well for me, but with the exception of one thing. Every time I run the macro, it changed the tab that needs to be change along with a 2nd tab associated to it. I explain myself:

1) I have 2 tabs, "ABC" and "XYZ".
2) On tab "XYZ", cells A2 to H2 are refering to position C2-K2 from tab "ABC". For example, A2 from XYZ is: "=ABC!C2".
3) On tab "ABC", I have data in column A2-A10.
4) Run the macro. Cells A2-A10 are copied to line C2-K2 of tab ABC. Working perfectly well for tab ABC.
5) However, tab XYZ is also affected. For example, the 3 first column has a reference error "=ABC!#REF!". And the 4th column is shifted and contains "=ABC!C2".

Any suggestions on preserving the references in XYZ?

Sub test()
Dim rng As Range, m As Integer, c As Range
Columns("c:E").Delete
m = 9
Set rng = Range(Range("a2"), Range("a2").End(xlDown))
Set c = Range("a2")
Do While c <> ""
'MsgBox c.Address

Range(c, c.Offset(m - 1, 0)).Copy
Cells(Rows.Count, "c").End(xlUp).Offset(1, 0).PasteSpecial Transpose:=True
Set c = c.Offset(m, 0)
Loop

End Sub