Selecting range in a column based on another cell value

Sorry for breaking the rules. I've posted the link in the main post.
I will also post this link to the other forum as well. Next time I'll just stick to one forum. Thanks for letting me know.

I've also attached a dummy spreadsheet, basically the values that surround the value in cell B1 should be copied to cell C2. I.e. cells A23:A54 copied to C1. However, if the value in "B1" changes, the range that is copied should also change.

Thanks,

My apologies again for the cross-post.