Macro for getting multiple sheets data into one worksheet

[Ylli B]

Hello,

I have 2 days that i try to do this and it just wount work"

I have a worksheet called "Menu" that contains in column A each name of the 680 sheets that are in the file.

each sheet has same structure-containing daily actions made on that sheet : sheet384: h55="24 Dec" g55=210100
h56="25 Dec" g56=800100

each sheet has daily changes
what i want to do is that i want to put one cell that contains =today(), and when i run the macro, all the actions(like 210100 or 800100) to appear next to each sheet name in the menu sheet.

pls help guys,