Trivial bit of SQL help needed (1 Viewer)

I have a line like this:
strSQL = INSERT INTO tbl1 SELECT * FROM tbl2
followed by db.execute strsql, dbFailOnError

This works fine but I'd like use a couple of variables for the table names so I can loop through lots of tables. I can't get the syntax right - can someone help please?

Thanks
Dave
ps I'm trying to fill an empty table (tbl1) with the entire contents of another (tbl2)

>>>so I can loop through lots of tables<<<

You may find this youtube useful http://youtu.be/sViWFBHg2NQ?t=3m35s

Part of this play list by Uncle Gizmo

Self sorted, thanks