Help creating a formula to pull data from one sheet into another

I have two sheets with data that I need to merge into one. The first sheet has three rows and the other sheet has several rows. I need to pull data from the second sheet 4th column if the value in the third column is authorization_date and the last column is not null into the first sheet after the last used column. Then I need to pull data from the second sheet 4th column if the value in the third column is decision_sent_date and the last column is not null.
If there are more rows in the second sheet than the first then I need to have the row where column E or Gin the first sheet is less that the value for the authorization_date or decision_sent_date duplicated to accommodate the extra values for authorization_date and/or decision_sent_date...an example of this duplicate row is shown the first data row in the End Results tab in the attached workbook. I tried

Thanks for any assistance with this is appreciated.
Seeki

FDibbins,

Thanks for responding and assisting me, appreciate the help. The first formula returns the first date on all three rows for authorization. The second formula works for the authorization date if I delete the records with null from Table B; but does not return expected results for the decision_sent_date - in this case it returns the first date twice and then the second date. The results are as follows:

2014-01-21 07:57:50.343 2014-01-07 17:08:19 870
2014-02-21 09:45:20.043 2014-01-07 17:08:19 870
2014-07-21 08:05:07.243 2014-01-21 08:21:40.970

I can get both to return the correct values when there are no duplicates/multiples using vlookup with a concatenation of the first two column in column A and separating the authorization and decision sent into two sheets (auth and sent) as follows:

=VLOOKUP(A2,auth!$A$1:$A$5407,5,0)
=VLOOKUP(A2,sent!$A$1:$A$5237,5,0)

When there are multiple decision I need to show that but duplication the row from Table A that the multiple authorizations and or decisions apply to....this is where I cant get it to work how I need it to work.

Thanks again, I appreciate you trying to help me!

I got it to work and display the 3 lines for both, I realized I started the decision sent date on the wrong row, once I made that correction it works perfectly for the single matches...but not for multiple matches. So it give the same results as using the vLookup ....both index match and VLOOKUP using separate sheets for authorization date and decision sent date yield the same results....and neither works for multiple so I need a way to insert the row(s) to accommodate multiples.

Thanks again
Seeki

Thanks for the suggestions. I am not ready to mark this as solved just yet as I am still trying to work through the multiple matches... and how to insert the row when the table B has more rows for a record than table A ... I am working on logic to get the difference between Table a record and table B and use that in an If statement
Right now I am using offset to eliminate the fist record to get just the three rows...but ideally I want to keep all rows form table B and do the insert of extra row(s) for the record on table A.

Thanks again

We manually worked the sheet as we found no way to automate what we needed.