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.