Fill Function down 8 rows then over 4 Columns

Okay, I apologize if this has been answered repeatedly. I'm a newbie and am not sure what verbiage to use in order to return an answer.

I'm creating a worksheet that populates from a table in a different worksheet by using and IF function with multiple criteria. The formula is created and is working, however I'd like to have it populate as follows:

Example:
Source table:
1
2
3
4
5
6
7
8

Would like it to populate the cells in a manner such as this: (|) represents adjacent cell

| 1 | 5 |
| 2 | 6 |
| 3 | 7 |
| 4 | 8 |

As it is now when I drag the fill box, it fills like this:

| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |

Any suggestions on how I can identify the cell range to be "printed to", so that I don't have to go in and manipulate the function at the top of each column?
Thanks for any help you can provide. (my apologies again for the poor verbiage)

DonkeyOte,
Thank you very much for responding. I'm attaching a much better sample of what I'm trying to accomplish, as I'm sure there is a much easier way to do this.

(see attached workbook)
What I'm trying to do is map the data from Sheet2 into the appropriate spots on Sheet1. Originally I tried to write an IF/AND function to no avail.
The original function said:

A2 =IF((AND(‘Sheet2'!$A2="2B",'Sheet2'!$B2="A")),'Sheet2'!$E2)

I would like to have the function populate the corresponding color areas with applicable data for each "TBL" listed. Without having to wade through a sea of FALSE statements.

Again, any suggestions are greatly appreciated! Thank you.