I'm sure the answer is in here somewhere but I've been reading posts that I
just find confusing and I feel like there must be a simple answer that I'm
missing.

I have a workbook with multiple worksheets and I have created a list of the
worksheet names (I named it sheetnames) and put it into a dropdown list in
cell C4 of my summary worksheet. I would like to find a formula that will
list cells b:4 to B100 from whichever worksheet name is chosen in cell C4.

Is this possible?

Thanks very much