Create a drop-down cell that brings information from other sheets on-click

Hi Everyone!

I am new to Excel and trying to find a way to do the following:
I have a Master List document which has several sheets (with information like - numbers codes et.). On the first Sheet I need to create somethin like a table and second row has to be a list where one can choose the desired department to display the data (that is on other sheets) related to that department.
P.S. when i create a list through data validation, i can't choose all the rows, or other sheets.

Below is the general look of the ML.
Capture.JPG

On the second row (A2), I need to display Department names, that you can choose, and after you choose one (let's say you choose Security Department), it brings all the info listed in SEC sheet for example to the SHEET1.
This info:
Capture2.JPG
To this sheet & cells.
Capture3.JPG

I am not sure if I could explain the problem clearly, as English is not my first language. Any help is appreciated. Thanks!