<My desired end result would be to have them all on 1 or 2 dvd's as data>
This is of archive concern to you?
So for the present and in order to preserve the original files, why not copy each item to the subfolder of a new folder on your HD.
Then when all are copied to your HD you can burn as many or few (new) DVDs as you need to sort and preserve your precious collection.
They will need your PC to run the individual files when you wish.
Editing and attaching one video part to another is a different matter.
At least you will have all your basic clips undamaged on fewer and perhaps better sorted DVDs.
The copied folders/files can then be deleted from the HD.