Hi,
I have a data base that I setup to be able to create multiple other sheets and pull the same information from sheet to sheet. The issue I am having is that the formula for the data validation drop list keeps updating back to the current sheet that the drop list is in instead of keeping the...