I've got a table such as this:

[![enter image description here](https://i.stack.imgur.com/fGwle.png)](https://i.stack.imgur.com/fGwle.png)
And I have another worksheet with the data transposed, such as this:

[![Transposed Table](https://i.stack.imgur.com/xNM24.png)](https://i.stack.imgur.com/xNM24.png) 

I want the **transposed sheet** to update whenever I update the **original sheet**.

I've tried to add another line beneath the transposed table, at line 4,
and pulling all the appropriate names:

**Cell A (Transposed)** <- **Cell B (Original)** (the <- means pull the contents of Cell B into Cell A). 

A4 <- Sheet1!D1

B4 <- Sheet1!D2

C4 <- Sheet1!D3

D4 <- Sheet1!D4 

The problem is, when I try to autocomplete the next line using the little plus (+) mark at the bottom of my selection, lo and behold what happens:

[![enter image description here](https://i.stack.imgur.com/GRI56.jpg)](https://i.stack.imgur.com/GRI56.jpg)

It makes cell A5, which **should** pull from cell Sheet1!E1, pull from cell Sheet1!D2 instead!

How do I auto-complete this correctly, without writing every single cell myself?