Does anyone has a video that shows how to consolidate workbooks?

[Jake]

Hi,
I’m looking for a video or visual guide that shows me how to use the
consolidate button. I read the Microsoft help for this but honestly I
couldn’t understand it. That is why I’m looking out for a video or screenshot
help.
For your reference I have a file where I need 10 different contacts to
provide me some data. I have sent the file (exactly the same file) and now I
need to put that in just one single file (worksheet).

Thank you in advance

 

[Ron de Bruin]

No video but,

You can use this add-in
http://www.rondebruin.nl/merge.htm

Or use code
http://www.rondebruin.nl/copy3.htm