Yes! that is the idea of what I need. How do I create the drop down menu to pull from sheets? also my sheet is a lot more complex. is the formula the same? can you show me where I would enter then cell numbers.

I have two columns that need to pull over but not every row. there is about 40 rows that need to pull over