Repair Google sheet feeds and Excel lookups

We have a web-based questionnaire which then feeds to an email box. Depending on what additional boxes are checked on the form once it is downloaded it will feed information to additional workbooks in Excel using lookup tables.

Somewhere along the line the tables were corrupted and we would like to have them fixed.