Cannot find the right formula for getting data out of a table

[tanjicas]

Dear all,

How the workbook looks like:
Each sheet in the workbook represents one month of the year.
In an additional sheet I would make a table with all the companies and 12 months of the year. I would like to put x in those months for company ABC in which that company has a contract (i.e. jan-march) and do the same for all companies.

Issue:
I need a formula which would find all the “x”s in January (column) and add the names of the companies (found in first column of the table) in the sheet January. Which formula would be suitable for this?

I know that I need to look for/find the "x"s in a specific column of a table, but than also somehow make sure that if in January I have 10 contracts the system will know it has put the first company in first cell thus in the second cell will put the second company that has a valid contract in that month.

Thank you everyone in advance for your suggestions and help!

 

[Roderick_E]

Ok, let's assume on the "summary" sheet it is structured like this. A1= has header "Companies". A2+ is the name of each company. B1=Jan, C1=Feb, D1=Mar and so on.
Now, assuming each of the "Month" sheets are named like the months in the "summary" (Jan, Feb, Mar...), AND that on these Month sheets, the companies are listed in column A.
Back on the "summary" sheet, in cell B2 the formula is:

=IF(ISERROR(MATCH($A2,INDIRECT(B$1 & "!A:A"),0)),"","X")

Drag this formula over B2 to M2 then drag down.

 

[tanjicas]

Thank you Roderick_E for your reply but I want to do it the other way around. My apologies for not explaining clearly enough! The additional sheet is not a summary but a data sheet from which the information will be taken and entered to the monthly sheets.
Is there any way that I can attach the workbook here? I am new to this forum.

Additional sheet: A1= header "companies" A2+ name of each company, B1=January, C1=February and so on. "x" is entered manually to cell B2 and C2 and D2 if company from cell A2 has a 3-months contract (Jan-Mar)
Monthly sheet: A1= header "companies" A2+ will be the names of each company (this is what I need the formula for), B1/C1- other data that is not relevant to this formula
My goal is to open monthly sheet for March and see a list of all the companies that have a contract in March.

 

[tanjicas]

I have found a way to make a table here, so this is how it looks like:

additional sheet:[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]companies[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]May[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]September[/TD]
[TD]October[/TD]
[TD]November[/TD]
[TD]December[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ABC[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Cardio Ltd.[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Sueda co.[/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Lion and brothers[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Guido[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Neft ltd.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]

monthly sheet January:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]companies[/TD]
[TD]other data[/TD]
[TD]other data[/TD]
[TD]other data[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

A2+ is where the company names should be shown.