same cell from multiple sheets into one column
 

I have many tabs that I want to copy information into a new sheet
within the same workbook. I need to Copy A5 into Column A, A10 into
Column B, C3 into Column C. Column D needs to be a total, which is
listed in Column H, but it in different cells, the cell above it always
says Balance. Column E needs to be the last populated cell in the
column that says balance. Headers should be A:Loan Number, B:Start
date, C:End date, D:Original Balance, E:Current Balance. Is there a
macro that can handle this?? If so, please help--my boss is breathing
down my neck!! Thanks!