We need a little more detail on where things are located. VLookup may not be
the best way to do this. Perhaps an example of what you have now and what
you want it to look like. Is the data to drop in the LookUp table? Where
does the sheet name come from for VLookup to find? Where exactly do you want
the data dropped and do you want to append it or overwrite it? etc..etc.

Mike F
"mwam423" wrote in message
...
need help, trying to use vlookup on a simple table to find sheet/tab name,
go
to that tab, drop in some data, and then return to table. any help
greatly
appreciated!