Auto Copy result to a new Cell on refresh

I was wondering if there was a way to auto copy a cell to a new cell each time the worksheet is refreshed. Currently the result is in cell Z4 and I want them copied into cells AA5:AZ24. Using a new cell each time.

Thanks for any input as I haven't found anything like this.