VBA: Automate Copy from Masterworkbook to SeperateWorkbook upon completion of daily inputs

Hello everyone,

I would like to automate the following process in a VBA macro:

1. I input data into a worksheet in a master workbook
2. Upon completion of entering the data, I would like to create/use a macro that automatically copies that updated information from the master workbook to a separate workbook. In that separate workbook I would like pieces of that updated information to go into 3 different worksheets (Paste Destinations).

Please note that the data I wish to copy are rows or parts of a row, and the destination is also to a row as well on the separate workbook.
Ideally I would like it to just search if there's new data, if there is then just copy it to the other workbook/worksheet.

For those who consider my plea for help, thank you for your time, I really appreciate it. I think this macro would be very versatile and useful for a variety of situations.
Personally, I have been thinking about using If --> Istext/Isnumber expressions to detect the text, but really any help or suggestions would be appreciated. If needed, I can provide sample worksheets of data to show exactly what I am looking for.

I don't actually want to create a new worksheet/workbook. My goal is just to copy updated inputs (rows) for the day from the Master Worksheet, to separate worksheets in a separate Workbook.

The following is an example to better illustrate what I need assistance with, with links to Google Docs:

Copy Destination Master Workbook:
https://docs.google.com/spreadsheet/...XZQTXVZS3BsWWc

Paste Destination Seperate workbook/Separate Worksheets:
https://docs.google.com/spreadsheet/...mZEX25UdEdYYVE

For example, lets just say that the master worksheet were updated daily, and I just needed to run the macro the macro to copy it to the seperate workbook's seperate worksheets (every day). This would save a lot of time manually updating the Separate Worksheets by copying and pasting over and over.

I can send the actual files, or get in contact with anyone if needed or would like to discuss these solutions.

Thanks a bunch for your consideration and help!