I have concatenated on Sheet1 that looks simlar to this example: 'Sheet2'!D4:D8 (this array is the content of Cell A4 on Sheet1)

In Sheet1 I need to get the average of 'Sheet2'!D4:D8 by using the formula =AVERAGE(A4). I am getting an error message from this formula. Any one know what I am doing wrong?