What I have is a CSV file, I received every day with changes.
Now what I need is to populate Sheet2 with the values in Sheet1
that is for text columns just copy the value

like this
--------------------------------
Sheet1 Sheet2
col A Col A
label sku label id
43000 43000
------------------------------

I tried with =Sheet!id (as I named the whole range "id") and some complex INDIRECT formulas that returned #Name! errors
I have to do more complex operations as there is not a single column I have to copy, but need to understand the logic

As I will get a different CSV file everyday and I just want to create a template I can insert into that new file, that calculates all rows and formulas automatically ...

So far I am stuck because I am not able to duplicate the values from Sheet1!A2 to Sheet2!A2 as the labels are different.
Other columns are more complex because they are made using CONCATENATE but so far as they are formulas they work fine.