Using FileExist to check name before saving file

Hi dmcgov I am happy to share so find the file attached.

There are a lot of Vlookups referring to customer lists and price lists but have taken out any personal information and the turned off the cell protection

I have also had to delete a lot of the pages like Purchase Orders, Delivery Notes and Pro-Forma which are all similar but needed to get under the 1Mb

Hope it makes sense