I hate to be the bearer of bad tidings, but by structuring your workbooks in
this fashion you've created a reporting nightmare. A far better approach is
to have all the data in a single sheet WITH A DATE COLUMN. Then it is
trivial to extract the data or create sopisticated reports.

Ron de Bruin has some tools that might allow you to pull all this data
together into a single sheet. See

http://www.rondebruin.nl/merge.htm

To employ that tool you will probably still have to visit each sheet and
add a date column to the data so that Ron's macro will generate a list that
contains dates.

If you cannot pull all the data together then you are left with brute force:
visit each page,
sort or filter by by employee,
copy,
and paste
all of which will have to be repeated for the next reporting effort.

Sorry



"chrisk" wrote:

Hi,
I have a workbook with 31 sheets a diary called April for this month
AX to FX is the info I want relating to the employee's initials in the G
column of the diary
There are multiple entries for the employee so he may reappear in row 9, 13
and 15 in column G of the diary

I want to pull all the lines that relate to that employee from the 31 sheets
of the Diary workbook called April for this month into a separate workbook
called BOB (employees name) and BOB, his name, is the reference in the diary
in column G (also in other cells if Bob does more than one job per day) but
in the G column.
There is only one sheet in BOB called Sheet1

There is a workbook for each month with 30/31 days (Feb with 28/29)

So I want to search the 30 worksheets (named 1 to 30) of the Diary (April)
for Bob in the G column
Then pull the data from columns A to F that relate to the row that Bob
appears in and put it in the separate workbook called BOB
There are the other 18 employees that I want to do the same with who also
populate the G column of the same Diary and who also have their own separate
workbook.

Thanks