Hi . Good site!

What I need help with is as follows:

I want to create a long list summary sheet aggregating the rows of data from 5 other sheets in the same book.

Formatting, column headings etc are consistent across the sheets, but the number of rows of data on each sheet is changing regularly

In my imagination this is a function which might be simple with some programming knowledge. I am afraid I am an excel user (relatively new to this 2010 version) with no experience of macros & programming to speak of.

Can I readily build this aggregated list function?

Thanks for whatever help you can offer