I need help generating a Main Summary Table based on data from tables across 19 sheets. Whether the Summary is generated in the same workbook or separately, is not crucial. Note that each sheet has several other tables not relevant to the Summary. Only one is relevant to the summary. It is a list of articles for a website, with cells giving the name of the author, deadlines, illustrations, etc. Each sheet represents a section of the website.

Each of the relevant tables in the 19 sheets consist of columns A through S. The relevant tables are located identically in each sheet, meaning that the top left corner is in the same cell (A5). Row 5 consists of headers. Not all tables are the same length, as they will vary between 12 and 70 rows. There will always be empty columns in the tables. There is a totals row. There may be empty rows immediately above the totals row, but not in between the 12-70 rows that are in use (column A has a text value for all rows currently in use. Cells in B-S may be empty).

Whether a row shall be picked for the Summary, depends on the value in column O, Q or S. If either one of these say “br”, the row gets picked. From the row, the values (some of them text) in columns A, B, and N through S get transferred to the Summary. In other words, the Main Summary Table shall consist of columns A, B, N-S from the sheet tables.

To top it off, I need a way of displaying which rows are new since the previous update of the Summary, or, if at all possible, new since a set time span (e.g. 1 week). In other words, I need it NOT to be automatic, as that would not allow my colleague to see which rows are new since her last visit (unless a time span solution is available). The purpose of the Summary is to allow her to see which tasks she has been assigned. The Summary will generally show between 100 and 500 rows, which means an update without any kind of highlighting or separate listing of additions, will leave the latest additions almost impossible to identify.

I have tried to find solutions using filters, recording a macro where they subsequently get copied, but always ending up with a problem of getting all 19 of them pasted in a continuous table, and certainly without finding a solution as to how I filter those with _EITHER_ O, Q, S carrying the desired value, rather than requiring ALL of them to carry it. Neither do I know how to produce the “new since previous” list/highlighting.

I am moderately familiar with basic functions such as the various IF-types, find.row, etc. I can record a macro and produce a button to go with it. I am not skilled at VBA, have only done some very rudimentary training, but begin to see that the solution may hide somewhere inside that magic Alt-F11 box.

I use Excel 2007. I have access to Excel 2010, but my partners may not always, so I would prefer 2007 compatibility if possible.

This is my first post to this forum, which has been of great use to me for different purposes. There are some great minds here. This time I have to submit my own post, as I did not succeed in finding anything sufficiently overlapping among the existing posts. Help would be much appreciated.