Accounting: How to Link General Journal Transactions to Ledger?

I am trying to set up a General Journal and Ledger in Excel. Right now, I am manually posting the dates and the numbers into the ledger. Ideally, every general journal transaction would automatically "post" to the Ledger as soon as it is inserted into the General Journal. But, I don't know how to do that!

I have attached a sample of the General Journal and Ledger.

Any suggestions on how to get the General Journal to automatically post to the Ledger (using vlookup, etc.)? I am open to any necessary changes, including reformatting everything.