Link a column to another sheet?

Kimbh ✭✭✭✭

Hi, If you set up one cell to link to another sheet. Can you make the whole column link to that column, or do I have to use a formula? I ask because I'm struggling with formulas and the xlookup I use in Excel is not uploading correctly due to how the workbook is set up in excel.

Thank you