Assume a worksheet which has scores (1-10) on four future dates on nine questions. Each row represents responses for one question. Likewise there are 20 respondents i.e. 20 worksheets which have the same structure.
One may want to summarise data from all 20 worksheets into one worksheet. The question and solution are more clearly explained in the attached file.
I have presented two cases here – Example 1 and Example 2 in this workbook.
You may also want to refer to the following related posts: