Create worksheet from data in another worksheet with lots of conditional or if...then ???? HELPT

if your source page is same you can use "MATCH", "INDEX"/"OFFSET" formulas to get data. For example in your pictures the dates are in the first row. You can find the that days column with below formula:

=MATCH(TODAY,SheetName!$1:$1,0)

this will return the column number of the date for example 2 for "8/26/18). you need to add 1 if you want to get the Goal/Hrs.

then you need to find the related person:

=MATCH(PersonName,SheetName!$A:$A,0)

this will return 8 for bob

then you need to use and index or offset formula to get the required data

=OFFSET(SheetName!$A$1, MATCH(PersonName,SheetName!$A:$A,0)-1, MATCH(TODAY,SheetName!$1:$1,0)-1,1,1)

or 

=INDEX(SheetName!$A$1:$R$20, MATCH(PersonName,SheetName!$A:$A,0), MATCH(TODAY,SheetName!$1:$1,0))

needless to say you need to replace generic names like SheetName and PersonName with the actual value you have.