How can I aggregate data from multiple files?

[stitchcreek]

I have multiple project files, each of which contains a risk log as one of its worksheets (not set up as proper tables).
The columns are identical for each log, but the number of populated rows will differ by project.

What's the best way to pull all of these logs into one master log? I'm using Excel 2010.

Any advice much appreciated!

 

[arthurbr]

You can try the code at Copy/Paste/Merge examples
or use Ron's addin RDBMerge, Excel Merge Add-in for Excel for Windows

 

[stitchcreek]

Thanks, I'll check this out.