Hi all!

I've been researching this for days and cannot seem to find the proper way of doing what I need! I feel like it's pretty simple.....

I have a master sheet where data is entered as such:

(A2:A5) (B2:B5) (C2:C5) (D2:D5)

Date Log # Building Rep
12/31/16 123456 5 Jane Doe
1/4/17 789012 10 Jane Doe
1/9/17 345678 15 Jane Doe
1/16/17 901234 20 Jane Doe



Then I have a worksheet for each log # and need the data from those line items to feed to specific cells on those worksheets. Ex. Log # 123456 is a worksheet and cell H1 is the date, H3 is the log #, H5 is the Building # and H9 is the Rep. How can I get the info that I enter on the master sheet to automatically feed to the other worksheets cells? Can it be a formula or does it need to be a macro?

Thank you in advance for your help! Any info is much appreciated.