I'm very new to this, but I was wondering if it's possible to write a macro that will allow a workbook to copy data from one worksheet (Main Data Sheet) to the other worksheets in the workbook. All the worksheets have the same headers in row 1. Column G in the "Main Data Sheet" consists of different vendor names (Vendor 1, Vendor 2, and Vendor 3). Each vendor has its own worksheet. I would like to be able to update the "Main Data Sheet" with new order information and based on the Vendor Name displaying in Column G, I would like that new information to be copied over to its respective Vendor Worksheet on a new blank row so that it does not override the previously copied data. I do not even know where to begin, but any guidance will be helpful. Thanks in advance!