Data summary listing

[Ruzzo]

I have 10 different worksheets.
All have data in the same range.

For example- each worksheet has data in the following ranges:
A3:A8
C3:C8
A11:A20
C11:C20
A23:A27
C23:C27

Data in A3 is Paul, A4 is William, A5 is Paul, C3 is Grayson, C4 is Liz, C5 is Paul
The data continues down in the cells as listed above, and on 10 different worksheets.

I want to list on a separate worksheet a detail of each item listed in these cells.

Is there a way to list out on this worksheet the following:
Paul
William
Paul
Grayson
Liz
Paul

It doesn't matter which order it's listed in...but listed in it's own cell on a sheet.
Is there a formula for this?
Thanks in advance
Ruzzo