Populate Data (Based on Drop Down Selection)

Can anyone assist in helping me with the following? I have a dropdown box and when a user selects an account from this box i would like the data from the orange box (another spreadsheete consisting of account forecasts & shipments for a particular product) to populate in the yellow fields for the product (depending on the account selection). Hopefully this make sense, not sure what type of formula i should use, thoughts? Appreciate any help...