Need to print multiple sheets of same workbook with the common date specified in a column

Dear Friends,

Please assist me in following

i have 10 work sheets named with Apple, Orange, Grapes..... etc... as sheet named
Each sheet same style of inputs column wise with different data
Only common input will be the date in Column A in all the sheets
We input all the sheets from A TO K column


Those 10 excel sheets gets updated on daily basis with different dates in A column.


What i want is - Required the macro to get the print of all 10 (or) more sheets in one run for those specified date mentioned in column A.
Macro should ask the date before the run.
All the 10 sheets to get printed separately with the sheet name.

Please support me in providing for my workplace

Thanks is advance.

Dear xladept


i have 4 work sheets named with 001,002,003,004 ( just for sample purpose i made 4, otherwise i have 80 sheets - even with alphabhet sheet names)
Each sheet same style of inputs column wise with different data
Only common input will be the date in Column A in all the sheets. Date input will be many (or)one on the worksheet in Column A
We input all the sheets from A TO H column


Those all excel sheets gets updated on daily basis with different dates in A column.


What i want is - Required the macro to get the print of all worksheets in one run for those specified date mentioned in column A.
Macro should ask the user for date before the run.
All the sheets to get printed separately as per the sample provided in Print form (please refer xl attached)

Note: I want the Numeric number sheet names to be in sequence and then the Alphabet Sheet names

Please support me in providing for my workplace

Thanks is advance.

Dear Forum Guru

Yes. i am getting the required data and it is printing as well.
Suppose if i required to have more columns from each sheet (Example Upto H current macro works, if i want to take upto K ). Please guide.

Thanks
anuwers

Dear XLA,

Sorry for the late. I have been using in work place since long the code and it was very useful. But one difficulty faced.

If the date is not in order, then it picks the first date and leaves the next dates of same.

Example: If our call is for date 22-may-2016

Suppose if the sheet no: 001 - A3 carries: 22-may-2016, A4 carries - 23-MAY-2016, A5 AND A6 carries : 22-MAY-2016

Then this codes picks only the first available A3 and did not pick A5 AND A6

Kindly guide.

Dear XLA department,

This is working fine. But rows getting changed based on dates of all sheets. Due to this my sequence number in C column gets changed. Hence without distrubing the date entry and other datas. required the data to work.