I took off the "Exit Sub" to allow the code to work for all vendors.

Once complete, it fills out Sheet1, but only for the last Vendor. Im guessing its overwriting each Vendor.

Sheet2 is populated with the info of all the Vendors. I was hoping it would create individual sheets for each vendor instead populating one for all.