Hi Spencer,

The #REF! errors are expected.

I have a workbook containing surveys that are linked to a results sheet through a series of indirect formulas. There are 409 condition surveys to be input but only a 100 in there now.

When the missing surveys are input into the main workbook, the indirect formulas grab all the necessary fields.

What I wanted to do was to paste all the current results as values whilst leaving the missing ones so that when I add the sheet to the workbook, it will populate the results sheet. (Does that make sense)?

This will then allow me to delete all the surveys reducing the size of workbook and allowing me to have all the results in one table.

Thanks