running a macro on multiple sheets

i need to run a macro on multiple sheets in a work book. the sheets (130 of them) start out with A,B,C. they run to Z and then repeat like AA,BB,CC all the way to ZZZZZ.

i have tried to come up with something to start with but i am new to vbe and don't even have a game plan on this. the worksheet names are in a lookup table called "lookupABC123". the macro that runs basically copies from "A" a range and then does some editing and moving rows to a master sheet. i got the macro to run on 7 sheets but in the future, it could go to 130 sheets.

any help would be appreciated.

Can you share your working code and the Lookup Table Sheet?

ok here is the formula workbook that has the lookup table in it.
dont have any working code, not sure how to start this.

http://www.filedropper.com/macrohelp

So here is some basic code that i just recorded
Sub COPYRANGE()
'
' COPYRANGE Macro
'
'
Sheets("A").Select
Selection.Copy
Sheets("MASTER").Select
ActiveSheet.Paste
End Sub

basically my macro just copys a range from Sheet A to the Master sheet and pastes it. i need it to do this repeat multiple times, going from sheet A to B to C all the way to ZZZZZ. Note that there are other sheets in this workbook that it doesnt need to run on.

thanks

dan

thanks, that worked. now my simple macro needs some help. let me play around to see if i can get it fixed. but thanks walrusggman, you have gotten me further that i could do myself!!!

so, here is what happens in my macro. i go to the "A" tab, and select the range called estimate1. this gets copied to the estimating1 tab in location C2 and i paste the values as text. from there i copy two columns from estimating1 to master. then three more columns from estimating1 to master. then i do some formulas in different columns in the master tab. then i delete some rows and then sort the data. once done, then i copy over the master sheet to bigmaster (the next available row) and then delete the range in master and estimating1 and then go to tab "B". then repeat. does this help?

ok here is the link to the workbook
http://www.filedropper.com/macrohelp_1

let me know

well, as for the macro that runs inside each worksheet, i have that working with one exception. it doesnt copy one cell correctly. that you can help me with, all the rest i think it will be ok.

so a little bit of background. when i copy the range from the A tab to the estimating sheet, i paste it into the page as text. one of the cells has data in it that says "Exhibit A". when i load up the B tab, the text will say "Exhibit B", with me so far? the problem is that when the macro runs, it copies into the macro the text that says "Exhibit A" on the A tab. if i run the macro on the B tab, it puts in "Exhibit A" into the cell but that is wrong, it should say "Exhibit B". the example below shows that the macro is recording the absolute text in the cell, when it should be using a relative "cell".

ActiveCell.FormulaR1C1 = "Exhibit A"

shouldnt it say something like" ActiveCell.FormulaR1C1 = cellA1.value (this is just a bad guess on my part, not knowing enough of VBA to sound competent)?

if you need me to upload the entire macro and excel file, i can do that.

i solved the problem above by doing the following:
I named the range where "Exhibit A" is found and then did
ActiveCell.FormulaR1C1 = "=Estimating1!Exhibit"

i think that should fix the issue with the macro, thanks for all the help.