Quote Originally Posted by yachrishere View Post
do I need these 100 files all to contain Sheet 2! that is where the Table/Database is. Or can I have the Vlookup to link to another file so there is only one master Database?

No, you should be able to keep your database in 1 file, and then just reference it from the others