I suspect that you have a number of worksheets to which you would like data transferred from a master or main worksheet so this would mean that you have a number of different text values in Column G.
To make it easier for us to help you, we need you to help us so could you please upload a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then post the link to your file back here.
Please make sure that the sample is an exact replica of your actual workbook showing all worksheets with the inputs shown on the master worksheet and the expected outputs in the destination worksheets. You can do this manually with just a dozen or so rows of input data. If your data is sensitive then please use dummy data.