I need your expert advice :)

I have my trial balance in a spreadsheet as follows:
GL Acct# Jan Amt Feb Amt Mar Amt.......Dec Amt YE Total

I want to drop the appropriate line item amounts into the year end P&L,
Balance Sheet, and Cashflow Stmt. Does anyone have any suggestions on the
easiest way to do this without linking each and every cell to the appropriate
cell on the financial statements?

Thank you for your help!
-Angela