Dear Sir, I have this Master Sheet with relevant information. I want a formula whereby when the master sheet is updated, the other sheets will also have the sheets updated by picking the Lowest rates, Highest Rates and Average rate displayed on the Master Sheet. I have attached the file please. Please bear in mind that the Master Sheet will keep on being updated, an that the changes should reflect in the other worksheets. Thank You.