Inputting Data to different tables using one form.

I am setting up an empty database for data input, because I don't want to sit down and import from excel for several weeks.
The idea is that I will have several tables with very similar records i.e. all the same fields and data types, but distinct so it is normalised the way I want it (more or less).
If say the different tables contained a different chapter of a book, I would want to direct each chapter to a different table.
What's the best way of approaching this. I was thinking that I have a combo box with all the different table names.
In VBA I would code something along the lines of a string variable (dim As String) being specified by the selected value in the combo box. This string variable would conveniently input into a series of control methods that would point each field at the correct Table e.g. [Tables]![StringValue]![FieldName].
Do you have any worked examples lying around for this sort of thing?
Cheers
Tim