I have an Excel Workbook, with sheets Intro and Data.

I am trying to write a macro that will
.. Clear data in sheet [Data]
.. Open another excel file in the same directory called "Fixed Calls.xls" and
copy the data from sheet [Sheet1] column A to AA to the current workbook
sheet [Data] columns A to AA.
.. Add a new field in column AB for all rows used that will add Z to A

I'm a novice so I don't even know how to do the import without using a
WebQuery, however I want to do this via a macro.

any ideas?