standardization of naming for several worksheets with different naming - for a newbie

[CCK0857]

Hi there, I am very new to this but I would like to seek your views on how to go about doing this.

What happened is I have 5 different worksheets which call the same thing by different names.
For example,
1. Worksheet1: apple
2. Worksheet2: applie
3. Worksheet3: green apple
4. Worksheet4: red apple
5. worksheet5: apple red

I want to combine all worksheets and name all these "apples".

I did a very simple find and replace macro with inputs and outputs as arrays but i realised that this is not scalable. If there are 10,000 different words (ie. potentially x5 inputs), I cannot be keying them into the array one by one. Furthermore, the array provides for a 1 to 1 input/output which may be messed up due to human error.

Like to check if there is a more scalable way of doing this, please?

Any advice would be greatly appreciated. Thank you!

Regards

 

[Fazza]

welcome

the idea of multiple worksheets with similar names & then combining them sounds, at a high level, a bad idea

this may not be what you're doing, but that is how I interpreted the description

if it is something like that, and maybe this is where you're going anyway, consider instead all the data on one worksheet with an extra field in place of the different worksheet names. so set up like database tables

for sure you'll get a better answer if you describe further details - cause right now, I think, the description of the requirement is insufficient. (and this I'd suggest has resulted in the delay in any answer)

all the best, regards, Fazza