Multiple Tabs & VBA Consolidation Help

[Weaseltron]

Hi all

I have a worksheet with hundreds of tabs of data, one per person, named as the person's name.

The person's name is in Cell A3 on each sheet.

I need a macro to look on each sheet for a specific value and, if found, to pull the person's name, that value and a number of cells to the right of it (lets say 13 cells in total including the value itself)

The person's name will always be in Cell A3 however the data I am looking for can be anywhere in the worksheet (not neccesarily in column A)

Any help is most appreciated, I have a very basic understanding of VBA. By basis I do mean basic as I only started learning it 3 days ago!

Thanks

 

[My Aswer Is This]

To begin with I think you mean you have a "Workbook" with hundreds of Tabs not.
Your quote: "I have a worksheet with hundreds of tabs of data,"

And then you said:

I need a macro to look on each sheet for a specific value and, if found, to pull the person's name, that value and a number of cells to the right of it (lets say 13 cells in total including the value itself)


What specific value???
Pull it?? What does pull it mean?? Pull it and do what?