Ms Excel Automatic Data Go to Desired Ledger .....

Yes.

If I am understanding you correctly, you want to be able to enter data on a generic form that will then post only to a specific ledger (held on a separate worksheet I am guessing), and then reset to accept the next item?

Easy enough.

As part of the data entry form have a dropdown list selecting the Ledger, and post to that ledger.

Use a Case Statement to give a value for the Ledger.

Sub TheSelectCase2()
    Select Case ComboBox1.Value
          Case "Purchase Ledger"
              LedgerSelection.Value = "PL"
          Case "Cost Ledger"
              LedgerSelection.Value = "CL"
          Case "Sub Contractor Ledger"
              LedgerSelection.Value = "SCL"
    End Select

Then using that value, select the ledger.

Sheets(LedgerSelection).Select

And then Select the are within the sheet for the post.