Multiple Files and Tabs

Hi,

I was hoping that someone on this forum might be able to help me right a macro for something I am trying automate. I have a little macro experience but the complexity of this request is out of my league.

The steps below are what I am trying to satisfy.

Create a brand new document that will....
1) Pull information from a tab in another file.
2) Insert the data into the appropriate cells via account # and department tabs.
Ex) Tab Dept 213.....account 123456
3) I need to able to easily pull this data from month to month.
4) When all the data has been pulled I want to print each separate tab.

I am not sure if that is enough information for what I am trying to do, but I think it is a good starting point.

I've attached and example, but the actual information will be in a total different file and location.

I really appreciate any help/advice.

Thanks!!!!

HRBonne