|When you say "automatically" do you mean that you want the data copied without the user taking any action?|
If so, would the entry of data in O3 be a good enough trigger to cause the copy to happen? In other words, you would enter data in B3, C3, D3, etc. and as soon as you enter data in O3, B3:O3 would get copied.
Of course, there's always the issue of errors. In the method described above, once the data gets copied, changing a value on the Request sheet would not correct the data on the Tracker sheet. Worse yet, if you made a change to O3, B3:O3 would get copied to the next row.
Have you thought about how you would deal with errors once the data has been copied?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.