Need Macro for managing information between two excel workbooks

I am not very much conversant with VB codes so forgive me for silly questions. Here is what i want to do.

1) Copy cell B4 from multiple worksheets of workbook named Daily.Total worksheets are 30 named as 1.2,1.3,1.4....... and so on till 1.31
2) Paste special in row B4 of another workbook's worksheet named Sheet1. Workbook name is Excel.

I have uploaded both workbooks.

Thanks

Mikhil


Daily.xlsxExcel.xlsm

Anybody for help on this