Formula to copy data to new sheet works but gives an error when run

I am using a macro to copy data from multiple sheets referenced in a list of cells and place the data it one master sheet.

The formula works and gives me the output i want however every time i run it it finishes with an error of 'Subscript out of range'

Here is the code i'm using

Please Login or Register  to view this content.

Any help to fix the error would be apprciated

Hi bm1

I think you may have a value in the last row of Column X which is not a sheet name in your workbook. Or you are reading a blank cell from the last row of Column X.

I hope this helps.

Regards