The problem is that your table names are in a table and that is why you are using cursors.

How many 'Volume_Control.tblFilenames_' tables are there and what size are they (rows). Is the number fixed or variable.

If you want all the results in one recordset then the use of a temp table would be required.

A join would be difficult as per above. The only way I can see to use a join would be to union all the tblFilenames_ together and join that result with LandRecords..tblLandRec_Index_Series.