copy from cells across multiple sheets and create one column of data on a summary sheet

Hi everyone,

I am new to the forum. I use excel a lot at work and really need to learn how to use it more efficiently. For now I've come here for help!

I need to copy the data contained in cells B218 through B222 in all of my worksheets, and create one column containing this information on a summary sheet. I tried searching previous posts, but they seemed more complicated than what I need to do.

Thanks in advance!
Amanda

Amanda,
Welcome to the forum!

This code is without seeing your data. If it does not work, I need to see a sample.

Please Login or Register  to view this content.

Thank you AB33. That worked!