How to get data from another sheet in many rows?

Closed
gunjan17 Posts 1 Registration date Wednesday September 2, 2015 Status Member Last seen September 2, 2015 - Sep 2, 2015 at 06:23 AM
Hello,
Im helping my dad out with some office software of his. so im basically trying to make it in excel. There's a monthly sheet and a daily sheet. in the monthly sheet only the dates are mentioned with the opening stock. comsumption. total etc. but when i click on suppose 1st jaunary, it will take me to another sheet where for 1st january there are different types of products, and i want to link the total of that day to the consumption and total and etc. i have to do this for all the days in a month and then for all the months too. Also, im linking the date with the daily details through with the help of a hyperlink, i have to do that for each, so if you can help me to make a macro for that too? its really urgent!
thanks a lot:)


here are the screenshots to understand it better!