copy existing code for another sheet

Hi,
Really need your advice.

1stly i never do vb macro before.
i have 1 excel with currently have 3 sheet coded with vb. This macro will call the excel source to display the filename accordingly in grouping.

Let say.
Sheet1 - will call the text having *OM4* and display in OM4 sheet
Sheet2 - will call the text having *OM5* and display in OM5 sheet
Sheet3 - will call the text having *OM6* and display in OM5 sheet

Now, company need me to add one more sheet called OM3 which will have in excel source soon.

Question :
Can i copy VB code from current OM4/OM5 sheet to the new sheet (OM3) and just rename the OM4 to OM3 in that code? Do i need to change anything else such as declaration and else? I tried to copy code from OM4 and paste into OM3 sheet using VB editor with just renamed OM4 to OM3.. but failed!. the ouput in OM3 is same as OM4 which i copied code from.

Please advice. Thanks in advance.


*Uploaded excel sheet in the question.
Not working sheet - SHEET1 and SUMMARY
Need to change SHEET1 to OM3 which will newly added.