Need macro or userform for Extract data from multiple workbooks by giving date range

Hi

I jst need to console data from different workbooks to one worksheet. There are 30 workbooks & each workbook contains one worksheet name as Data. The work i am currently doing mentioned below step wise
1) Open workbook
2) Apply filter on whole data
3) Select dates from "J" Column (E.g 02/10/2014 to 02/20/2014)
4) Then Copy whole filtered data
5)Paste into New workbook
6) Open another worbook
7) repeate Step # 2,3
8)Then paste whole data in below the first data New Workbook (In which we have paste the first data below that i will paste this data)
These steps i have to do manually it takes almost 1hr daily
After pasting all 30 workbooks data in one workbook i have to make pivot of it & sent it to my Manager.

What i need

I jst want a excel macro that will ask me date range from which i have to pull data from all 30 workbooks.
Once i gave date range will jst click on button say extract or pull. It willl console whole 30 workbooks data from the given date range in a one worksheet.

I hope the given information is sufficient for you.

Please Help.
Thanks
----------------------------

Would each workbook to be filtered be for Sheet1?

"1) Open workbook
2) Apply filter on whole data"

Hi John H. Davis

Yes each workbook would be filtered for sheet1 named as DATA "J" Column

Thanks
-----------------------

Maybe?

Please Login or Register  to view this content.

Hi John H. Davis

Thanks for your quick response. Can you please help me with the complete file.

Thanks
-------------------------------

Not sure what you mean by complete file?

Hi

1) Excel file that contain macro.
2) Also want to know that every time i have to enter start & end date in macro.

Thanks
--------------------------

I can load it, but I need to know the Path and the Destination (ie activeworkbook and sheet names). 2). No you'll have to enter it into the Inputbox's..

Hi

Below is the path & destination

C:\Users\g532492\Desktop\Tracker

Thanks
--------------------------

What about the name of the workbook and sheet you'll be working from?

Hi

Name of Workbooks are different individuals names & sheet name in each individual is data

Thanks
------------------

I added it too the file with the changes you indicated.

Hi John H. Davis

Thanks Alot for your help You are Superb..

Thanks
----------------------

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.