autopopulating multiple excel sheets data into one sheet

[rikinsoni]

i need a macro where there will be one master sheet in a particular folder and it would get auto populated with the data from other excels in the same folder when the master sheet is opened.

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx