Expanding a range across multiple sheets

I think that this is what you are intending. Seeing that you have tabs for each division, there is no longer a need for the Data Validation on each tab. I eliminated that DV in B2 of each worksheet. As data is added to the download worksheet, each tab is automatically updated.