VBA Code for a Single Sheet

So im very new to the use of VBA in Microsoft Excel. I have created worksheets for work and mostly through help from online sources have gotten a working code I use.
The thing is, I want to merge multiple Workbooks together and I need to get my code so it effects only 1 Sheet of a workbook. Otherwise all my sheets conflict and stuff.

I have a Excel document with 2 Sheets
Sheet1 Venison
Sheet2 Drops

Here is the Code for the Workbook.

Please Login or Register  to view this content.

I want this Code to only effect Sheet 1, Becuase I want to merge another document that has this code with different positions for its Sheet.

Long Story Short.

3 Documents - Sheet1 Venison, Sheet1 Elk, Sheet1Bear. All different workbooks that im merging and need all their code sets to work.