Prepopulate cell values based on selection from list

[kumar1803]

I have a list where I have banks name. Every time I select a bank from the drop down list, I would like a prepoulate cell values automatically like for example below: Any help is really appreciat

SELECT A BANK HERE
LOAN VALUES			DEALER RESERVE SUMMARY
Loan amount	$25,000.00		Monthly payment		$497.87
Sell Rate	7.24%		Number of payments	60
Buy Rate	2.99%		Total interest		$1,946.37
Loan period in years	5		Total interest		$4,871.94
Start date of loan	3/1/2015		Total cost of loan		$29,871.94
Difference	0.59		Total Reserve		2925.57
				Dealer Reserve		2047.90

<colgroup><col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;" span="6" width="109"> <tbody>
</tbody>

 

[Roderick_E]

Easy enough, we just need to have what i call a hidden helper sheet that contains the stored data associated with each bank.
I imagine each bank has different data?