add data from another worksheet every day

I have a worksheet named stock_price_check-test. i will open another worksheet named Bhavdata. form bhavdata the code should bring the close price and enter in col H after entering the date of the bhavdata in col G. then the macro should evaluate the price . if it is greater than the base price it should be in GREEN otherwise in RED. then it sould calculate the total price in col I. then it should compare the price and show profit or loss in col J. find out the percentage of profit and loss in col K.
the process should continue for each forthcoming day adding data to the right.thanks. pls see the attachment.

thanks for the reply.

the formulas which has been shown has to be incorporated into the macro so that it will do the work automatically. the macro should also to show the date of the bhavdata in column G as requested.No need to alphabetically arrange.you may pls refer to the code which you have created for me earlier for guidance.pls see that the filename bhavdata , sec_bhavdata_200319 etc should be taken as one by the code. both the file will be opened .when new bhavdata is opened the latest data should be appended. the columns will extend towards right.for your guidance and test, i have uploaded bhavdata of three different days with a gap.

thanks for the macro. when i run the macro it gives an error . "Runtime Error 6" overflow.
though it gives an error, it shows the data in col G-----K.
I opened bhavdata of 19th .
then i close it and opened bhavdata of 21st.then the previous data is erased and new data according to the 21st is added. it should not happen. after filling the data of 19th, when i run the macro for the second time of course after opening bhavdata of 21st, the new data should be appended from col L. it should continue.
pls see the attached macro enabled file . now pls open bhavdata of 21st and see the result.bhavdata uploaded in post No.3

Originally Posted by Mumps1

STOCKPRICECHECK doesn't refer to the filename. It refers to the worksheet named "STOCKPRICECHECK". It doesn't matter what the filename is of the workbook containing the macro.

thanks for the response. yes , i meant to say that the worksheet name. can you make it universal like stockprice.* like stockpricecheck_july 2019, stockpricecheck_aug2019, any sheet name for that matter which starts with stockprice

Hi, thanks for the edited code. it works fine.
Now i would seek some clarifications.
when i get a new code i insert a module and paste it there. since i have a number of codes thus stored in my personal workbook, and when i open the macros button there is a long list of codes. to identifiy the required code i rename the code in properties window.
for example for your latest code i have renamed as stockpricecheckMUMPS210419.
when i open the code in the code window i See on the first line of the code=====copydata
this is supposed to be the name of the code.
is there any suitable way of renaming the code other than my method?please see the attached file