Copy certain cell value from one workbook to other

[hasandocjimc]

I have a workbook named Salman, in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

I have another workbook named Hossain, in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

I have another workbook named , in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

Now I want to copy all above cell value to another workbook named Profile_summury automatically before save above 3 workbooks.
Please help.
Thanks

[nilem]

Maybe something like this (assuming that all the files are in the same folder)

Please Login or Register  to view this content.

[hasandocjimc]

Thanks Nilem, It does not work.
I need those values of salman workbook copy to b1, b2, b3 of Profile_summury respectively.
values of Hossain workbook copy to c1, c2, c3 of Profile_summury respectively.
values of ____ workbook copy to d1, d2, d3 of Profile_summury respectively.
and so on.
Please help

[nilem]

Please Login or Register  to view this content.

[hasandocjimc]

Thanks Nilem.
But it show run time error 13. type mis match error. highlight arr line

[jindon]

Array function will store Object reference without it property.

Please Login or Register  to view this content.

Or avoid use of Transpose function

Please Login or Register  to view this content.

[hasandocjimc]

thanks you are great

[hasandocjimc]

I have a workbook named Salman, in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

I have another workbook named Hossain, in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

I have another workbook named , in which
B1 cell = name of person
AW7 cell= Mobile number of that person
B3 Cell= Birthday

Now I want to copy all above cell value to another workbook named Profile_summury automatically before save above 3 workbooks.
I need those values of salman workbook copy to a2, b2, c2 of Profile_summury respectively.
values of Hossain workbook copy to a3, b3, c3 of Profile_summury respectively.
values of ____ workbook copy to a4, b4, c4 of Profile_summury respectively.
and so on.
I need transpose function
Please help