Cell Mirroring? AND Automatic-autofill

[Coolfridgeguy]

Is it possible to make a cell in a sheet be exactly the same as another cell in another sheet without using =sheet!2A1, I need all the cells in a column to show whats on another sheet without having to input the function down to the 1000000th row.

Then I need this sheet to automatically autofill multiple functions to display the rest of data.

this sheet has to be idiot proof and I cant rely on staff all knowing how to use excel

Are either of these things possible?

Thanks!

 

[hippiehacker]

no only with formula or macro

 

[Coolfridgeguy]

ok how do I do that with macros? I've never used macros before