I have a sheet 1 with raw data inserted. Each Sheet 2,3,4 within the same workbook has another spreadsheet that needs to read the raw data from sheet 1 from a particular column. I would like to have a formula like =sheet1!d30 which would be inserted in sheet 2,3,4 etc. where the column is a variable meaning Sheet 2 would use column D data and Sheet 3 would use column F etc.
Very new to Excell.
Would love some help.