Try this response to a similar query:
http://tinyurl.com/exxre
(one way which automates it using non-array formulas)

The sample construct given in the thread is still available at:
http://www.savefile.com/files.php?fid=9963202
Auto-Filter_Data_To_Resp_Sheet_Non_Array_Approach.xls

The key column "Cat" in the sample would be equivalent to your key col:
"Name" where your team member names would be listed down in the column, eg:

Name1
Name2
Name2
Name1
Name3
etc

And the individual sheets would be named to match exactly
the above names listed in the key col: Name1, Name2, Name3, ...

(Just adapt the sample to suit)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ian1" wrote in message
...

Hi all

This is my first post on these forums and I'm sorry if there's an
obvious answer but I've trawled the help searches and the closest I've
come to a solution is the 'paste special' facility mentioned in a
previous post on this forum.

The problem is a spreadsheet set up for petty cash entries. Sheet 1 is
an overall record of expenditure. Each team member has their own
worksheet. What we want to do is to make excel automatically take
data entered for each specific team member, and copy it to their
respective worksheet. The data to be copied is all in the same row.

There is a column on Sheet1 for -'NAME'- which could be used as a
keyword to specify which sheet the data should be copied to.

Any help would be greatly appreciated as we're kinda stuck on this.

Cheers


--
Ian1
------------------------------------------------------------------------
Ian1's Profile:
http://www.excelforum.com/member.php...o&userid=31599
View this thread: http://www.excelforum.com/showthread...hreadid=512899