Help: Auto insert data from another column with single input

Attached.

In that table, on sheet 4 I had to copy paste data from E5:E29 to D3:D27

It's easy to do it vertically, but I will also need to do the same using the data from sheet3 horizontally i.e E5:K5 (It would involve another calculation table but let's deal with that later).