Microsoft Excel
 

I am using a workbook with several pages. I need to find a way, besides
having to filter the data each time, so that when I update the master sheet,
the changes appear on the supporting sheets. A drop down box with release
dates, was created. Each supporting sheet shows all the company's names,
user #'s, for that particular date. What I want to do is link, or use a
formula, that will make the company name and user # appear when a date is
selected from a drop down box. Can anyone help?