how do I transfer data from beginning balance and transaction summary tabs into the trial balance tab using only formulas?

I need to put in Formulas only, not hard entries.

VIL T ICIP Home Insert Draw Page Layout PUIMUS Data From Text/CSVP Recent Sources Queries & Connections From Web Existing Connections Refresh Properties From Table/Range All Edit Links Get & Transform Data Queries & Connections Stocks Geogra Data Types X fou 135982 Debit Balance Credit Balance 135,982 54,500 5,321 158,122 109.821 602 Account Balances as of December 31 G/L Acct Long Text 100000 Bank Account 110100 Accounts Receivable (Direct Posting Account) 110150 Allowance for Bad Debts 200100 Inventory-Finished Goods 200200 Inventory. Trading Goods 200600 Inventory-Operating Supplies 9 200900 10 200910 11 200920 12 200930 13 210000 Prepaid Insurance 14 215000 Prepaid Rent 15 220110 16 220210 Production Machinery, Equip & Fixtures (Dir. Post) 17 220310 Accumulated Depreciation - Machinery (Direct Post) 18 300200 Accounts Payable (Direct Posting Account) 19 300400 Payables-Short-Term Notes 20 300500 Payables-Long-Term Notes 300700 Payables-Salaries and Wages 22 300600 Accrued Expenses 321000 Accrued Tax-input 24 329000 Common Stock 25 330010 Retained Earnings (Direct Posting) 4.800 5.000 162,000 21,600 16.050 59.334 11.206 20.400 2.538 4.178 200.000 290 200 beginning bal Transactions Summary 630 R27 General Journal 630.827 Trial Balance COA Type here to search DALL OS AutoSave on 2 8 Project 2. Journal Entries in Excel - Version TWO (Empty) (1) - Excel File Home Insert Draw Page Layout Formulas Data Review View Help From Text/CSV P Recent Sources Queries & Connections Do From Web Existing Connections Refresh Properties Stocks Geography Data - From Table/Range All Edit Links Get & Transform Data Queries & Connections Data Types 1 Monthly Tranaactions Values Sum of DEBIT Sum of CREDIT 59020 187179 248060 44520 3500 92000 362 76000 51264 115137 13200 4 Account Account Name 5 100000 Bank Account 6 110100 Accounts Receivable (Direct Posting Account) 110150 Allowance for Bad Debts 200200 Inventory-Trading Goods 200600 Inventory-Operating Supplies 200910 Inventory-Finished Goods (Direct Post) 200920 Inventory-Trading Goods (Direct Post) - 212000 Prepaid Advertising 300000 Payables-Trade Accounts - 300200 Accounts Payable (Direct Posting Account) - 300700 Payables-Salaries and Wages 16 600000 Sales Revenue 17 - 610000 Sales Discount 741500 Utilities (electricity & phone) 19 742100 Shipping Expense - 780000 Cost of Goods Sold 21 blank) iblank) 22 Grand Total 92000 82362 114412 62400 15 266060 1840 2538 2069 166401 840362 840362 24 Adjusting Entries 27 Account Account Name beginning bal Values Sum of Debit Sum of Credit General Journal Trial Balance Transactions Summary COA Type here to search DOLL Eile Home insert Draw Page Layout Formulas Data Review View He Le From Web From Text/CSV Recent Sources Existing Connections from Table/Range Get & Transform Data Queries & Connections Refresh E Properties All Edit Links Queries & Connections Stocks Ged Data Data Typ A2 x fe 24 Adjusting Entries 25 28 Values Sum of Debit Sum of Credit 1018 514 400 600 26 27 Account # - Account Name 110150 Allowance for Bad Debts e 200600 Inventory-Operating Supplies 30 210000 Prepaid Insurance 31 e 212000 Prepaid Advertising 2220310 Accumulated Depreciation Machinery (Direct Post) 300200 Accounts Payable (Direct Posting Account) 740000 Supplies Expense 740400 Insurance Expense 741200 Bad Debt Expense 741500 Utilities (electricity & phone) 3741800 Depreciation Expense 741900 Advertising Expense 40 e (blank) (blank) 41 Grand Total 900 2663 514 400 1018 2663 900 600 6095 6095 49 beginning bal Transactions Summary General Journal Trial Balance COA Ready Type here to search Search Javier amander - har B Home sert De S - Project 2. luma Entries in Bred Version TWO Emo Page Layout Formulas Data Review View e ries Connections Ercel Help Recent Stocks Geography Analysis - SA Beginning Balance Adjustments Adjusted Balance 100000 Bank Aco 11000 Ace r ct Posting Account 110150 A ctor Bad Debts 200600 Operating Supplies 200900 story R e al Drect Post 200910 ore Good Deset Post 2010 o g Goods Dent Post) 200930 b y S hed Goods Derect Post 210000 Prepaid Insurance 215000 Prepad Supplies 220110 Land Crect Post) 2010 Production Machinery top & Focus Pow 2010 Ac e r Machinery Direct Post 300200 Accounts Payable t Posting Account) 300000 Payables Short Term Notes 00500 Payabongle Notes OPW 360 Acer Expenses 700 Acer begri Traadio Summary General Journal Trial Balance COA DELL 020000220 28