I tried to copy and paste with ADO, but it does not work, maybe some one can
tell me a simple Macro

I have 1 workbook to copy date from many workbooks

1. Wkbook A looks like this
a b c d
1
2
3
4

2. All other wokbooks

a b c d e f g
1
2
3
4
5
6

Today I want to copy from all other workbook only e1 to G3, I copy and put
it to workbookA to A1to C3, but next day I will update by copying E1 to G6 ok
on this problem I can use dynamic range

but how can I have a Macro to let me:

1. Chose the file/workbook name to be copyied and pastied

2. when I put the cursor in cell A4, it will be pasted starting from this
cell, coz there will be many workbooks to be pasting in the workbook A which
is as a data bank for me.

The main problem, I want the Macro to put where I put the cursor in Workbook
A.

I appreciate your help.

Frank