Dynamic Macro

Good evening. This is my first time posting in a forum so I hope I am doing this correctly.

I'm setting up a workbook that will have a new tab added to it every month exported from SalesForce.com and will have a different tab name each time. I have solved for that I think using Sheets(Sheets.Count). One of the things I need to do with this macro is look at the previous tab to compare for certain types of changes. The code I currently have forces me to choose the location of my file that I already have open only to ultimately have me pick the sheet I need, i.e. previous sheet.....kind of frustrating. I want the code to get it itself. I know Set ws = Sheets(Sheets.Count-1) will get it because I can take that and follow it with Msgbox ws.Name and it will give me the name of the tab. The other thing is the amount of data populated in the tab and number of changes can vary so I can't have ranges "hard-coded" or I would obviously miss something or grab too much. Anyhow, I started by simply recording the macro and some changes but am not quite there. I've seen things here before that have helped in the past but cannot find anything directly related to what I am trying to do here. I have not set the buttons yet until code works the way I describe. I am hopeful someone can help with at least one of the macros then I can adapt the solution to the other 2. Any help/guidance is greatly appreciated. I have attached the workbook I am working with so you can see what I have so far.