I have a list which contains data in N1, N7, N13 and so on.
I wish to automatically transfer this list (when new list is opened), to
simple A1, A2, A3 and so on. I cannot find a function which allows this. When
I try 'writing' the first few rows ie '=mysheet!(N1) ~ (N7)' etc and dragging
down the list resets immediately after my last input.
Please help if this makes any sense to you?

Thank you.