Auto Copy Spreadsheet Design

[Exquisik]

I think the title might be a bit misleading to what I really want to do, but hopefully it won't cause that much of a problem. Please forgive me if it does...

I'm new to the forum and have been browsing this forum attentively the last couple of weeks for tips and solutions to helping me with my Excel project. I must say, this is a wonderful community and I'm greatly appreciated for all the Excel experts out there that are contributing their time to help novices like myself and others.

Anyway, I'm currently working on a financial spreadsheet project for a non-profit organization as a volunteer but currently having a problem trying to put it all together. This is possibly the only step I need left to finish up the whole project. The problem I'm having is that the organization has multiple sites that specialized in different area, thus all having different accounts that they must managed. So I'm trying to create a master spreadsheet of Account Balance that can be adjusted according to each site's needs.

For example, if Master_Copy has the Account Balance spreadsheet with blank cells but the cells are highlighted/boxed/formatted/functioned to work as a spreadsheet as a whole; then by entering a value into the blank cells, the value will then be transferred to a Account_Balance workbook (which is the exact same as the Account Balance spreadsheet from Master_Copy) that the site will be using. The problem I'm having is that, if the site hides rows and columns from Master_Copy, how can I tell Excel to copy the same rows and columns hiding from Master_Copy to Account_Balance?

In other words...

I have two workbooks, Test_A and Test_B. Test_A is a master version of all other workbooks in the Financial Project. Test_B is a copy of one of the spreadsheet (Sheet_A) in Test_A, so basically whatever happens to Sheet_A in Test_A, it will also happen to Test_B. All spreadsheets in Test_B will have the same design as Sheet_A. Now when I enter all values that I needed to Sheet_A and have blank rows/columns that I want to hide, I want Test_B to be able to hide the same rows/columns that I hid in Sheet_A. Is this possible?

I'm sorry if it sounds confusing, but I would be greatly appreciated if anyone can help me with this. I'm a novice to VBA but I can work with it and would be willing if need to.

Thanks in advance for all the help!

I was going to attach a file to the original post, but thought it was not necessary. Sorry.

I have attached a dummy copy of the workbook with multiple spreadsheets. As you can see in the workbook, Test_A and Test_B are exactly identical, and there are empty cells under 'Account' in A32, A34, A36, A38, and A46. These are the rows that I want to hide (32, 34, 36, 38, 46). But what I want Excel to do is to auto hide the same rows in Test_B if I hide them in Test_A. There are probably 12 of the same spreadsheet in one workbook, each for different month, but they all should be identical to each other.

Thanks for the advice Dave!