I have an idea but am not sure if it can even be done. If it can then I need
help to realise it...

I have a worksheet with a list of companies and data relating to them. On a
second worksheet (same workbook) I would like to create something that
filters the info on the first. For instance if someone chose one company
from a data list, then all of the information relating to that one company
would appear on the second worksheet.

I can create the list on the second worksheet so a company can be chosen but
nothing more. Any ideas or advice?