WANT a macro to import data and update fomula cells

[harishb63]

Sir i am uploading a file in the attachment please check


sir i want to import some data from "data" sheet to "banknifty-sbin" sheet
the data i wanted to import is "A" column (ie date column from "data" sheet to "banknifty-sbin" sheet )
then

i want to update the formula cell up to last date in all the column
(if i do before the data is entered i will get "#DIV/-?" this format which i dont want)

please help to make my excel automate

as the sheet i am giving is a sample sheet in original file i have around 15-20 sheets
which make my job bit difficult

thank you sir in advance
harry b