How to set up filtering and output to a cell?

Question

excel

Task: to make it so that when filling in the columns there was a drop-down menu with data. The data is entered either manually or through the issuing menu. The data are on adjacent sheets, please advise how best to complete the task.

Answer 1

Use the functionality of Excel: Data - Data Validation.
It allows you to select a cell value from a predefined list.