Update MasterWorkBook when I click a Cmdbutton/macro

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

==========
MODERATOR's NOTE: This question has been crossposted here.

would All the data from sheet1 in "IN.xlsx" be imported into MarcGoProject? Just as new lines in the received sheet? Are the files in the same location?

This will just append the entirety of the baby sheet onto the the received:[/CODE]MarcGoProject4.xlsm

Please Login or Register  to view this content.