Truly am not understanding

I have a workbook with three sheets in it. I am having the hardest time figuring out how to create a formula to input data from a table into a column. Maybe what I want in my head just wont work idk....