Automatically Update my masterworkbook when i add stuff to my babyworkbook

[MarcGo]

Hello so here is problem

I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers
sheets name :
sheet1=ADDITEM
sheet2=ITEMLIST
sheet3=RECEIVED
sheet4=SHIPPED
sheet5=STOCK

now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has one(1), sheet1 it also has a header

so the problem is i want to automatically update the master workbook sheet3("received") when ever i update or do something with my babyworkbook.

or for example i changed something in my babyworkbook then saved it. then when i open my masterworkbook i have a button that i can click so my (received)sheet will be updated.



PLEASE HELP.
BEST REGARDS (Y)

-MarcGo

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...ton-macro.html

Thread Closed.