Unable to lookup value from one sheet and copy rows from another (multiple)

[Lassie1982]

Hiya,

Newbie here needing urgent help......

Have just coompleted VBA into course and am more confused then when i started - boss is expecting a miracle though and I am running out of time..

I have a workbook that contains 80 worksheet.
79 of which contain a unique value in cell A1
and one which has each of those values in a colum A, followed by another 10 colums with data.

So I need a code to get the value that is in cell A1 on Sheet ABC, look this value up on Sheet called Raw Data, then copy the row that has that value in colum a...then paste that back into SHeet ABC from the current active cell

and of course i need to do this for all 79 sheets.

I have tried but am failing miserably and getting more and more stressed by the minute

Please Help!!!!

****I have added a short version of the file, to better explain what I mean:
-Take the value in Cell A1 on the sheet ABC(there are 80 of these sheets - all different names, but the required value is in cell A1 on all sheets)- Look this value up in colum A on sheet Raw Data (i know there are only 3 there at the moment, the real spreadsheet has about 3000) then copy the row (C:M) and then paste it to the active cell in spreadsheet ABC (it can't be an absolute referance becuase the row it needs to go into will differ on each sheet)

The reason I was thinking of vb as a solution is so that I do not need to enter a lookup formula for each colum on each sheet

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I have edited it to remove unnecessary words

[royUK]

I don't think that you don't really need VBA to do this. Attach a small example of what you mean