Thanks Roger you macro helped me.

"Roger Govier" wrote:

Hi

Ron de Bruin has produced a lot of code for carrying out these tasks.
Take a look at
http://www.rondebruin.nl/copy3.htm

--

Regards
Roger Govier

"Mandeep Dhami" wrote in message
...
Hi,

I have few excel files that needs to be consolidated every month. All the
columns in these excel files are same just that the data in each of the
files
would vary in terms of number of rows.

I want to consolidate all these excel files into one master file, where
data
would appear in one row after the another row.

Names of the files would change every motnth. Can you help me with this
request.

Cheers,
Mandeep