See Ron de Bruin's site for code and sample workbook

http://www.rondebruin.nl/fso.htm

Scroll down to "Copy sheet from each workbook"


Gord Dibben MS Excel MVP

On Wed, 16 Dec 2009 09:01:02 -0800, Chi
wrote:

Hi,

Would you please show me how to import Excel sheets from different workbooks?

Thanks
Chi