Need help with Excel dynamic report

[userx69]

HI everybody I need to build up one dynamic report.

Here is the task:
1) Everyday workers fill up with records in each sheet (record count can be different, because there is a "List" table)
2) Each day is in one separate sheet (for example: 1st June is in sheet with name 1, 2nd June is in sheet with name 2 .)
3) ALL sheets are named 1, 2, 3 ... 31
4) And in the sheet with name "ALL records" must be generated all records from sheet 1,2, ... 31

Here is my Example

Could you me please?

 

[maheshmaxi]

ok, this thread had a specifc requirement involving lists, and I believe below link would help,

http://www.mrexcel.com/forum/showthread.php?t=403594

copy the code t oa new module and change the sheet name in the code, then run the macro

Is it necessary to verify the count of rows? and how to verify by manual only or is there any formula to count the rows of all sheets which is not blank in particular column (mandatory)? Pls help me...

 

[sanrv1f]

not sure I understood your requirement, if you wish to copy a particular range from all the sheets, then this might help

http://www.mrexcel.com/forum/showthread.php?t=386112

 

[maheshmaxi]

thanks a ton sanrv1f