I'm extremely new to Macro's and have been self educating for a couple of weeks now. Let me try to describe my situation with as much detail as possible to hopefully get a solution in lehman's terms.

Situation:
I'm in charge of a hotel's revenue management and have been pulling all of the data and statistics from various reports from our reservations system. Obviously we break our revenue down into the months throughout the past year and the future year. With occupancy and revenue changing on an hourly basis, I need to have a macro that can easily pull the numbers through the system. The reports I'm pulling my info from are on a monthly basis and are produced from our reservation system in pdf form. I've currently been converting the pdf's into .txt files prior to recording the macro. For example - I will save the file as October - OTB as pdf and save it to .txt before recording, than in the recording of the macro pull it up manipulate the table and transpose it and pull what info I need and copy it into my Revenue Workbook.

Concerns:
Is there a way that I can use set of commands within a macro and plug in each month variable month to attribute to the document I pull data from and copy it to?
I'm also having a problem with the reports I pull info from: If it is a current month it will give our Month To Date Revenue in the middle of the table, splitting consecutive days. For example on October's report I will have a row stating our Month To Date Revenue in between rows 10/09/12 and 10/10/12. Within this October excel report I've tried to do this but it didn't stick: While recording a macro on my main Revenue workbook, opening the October report and using the find and search feature, I than search for a word that will consistently be on each monthly report within that row "Forecast". I then "delete row". Unfortunately when I actually run the macro, the row I wanted deleted is still there and it pulls the data from that monthy report (October Report) and fills in into my Revenue document making the data inaccurate.

Please help!

Regards,
Ryan