I need formula or macro to filter a number of items from different tables at single filter

Personally I'd simplify this task by having a single database.

Identify all the unique field names from your existing tables and create a new table that contains all these fields, Add a new field which will contain a value that identifies the current tables so that you can then filter for the individual table records. i.e. this new field would contain values like
Rate
Head Count
Hours
SOW Mapping

Not all records of course would contain a value in every column.

Hi, Welcome to the forum, may be this formula approach, I put formulas for table 1 and 2, see you can adopt to this for table three and four.

Originally Posted by Karthikeyannb

Thank you so much Richard but still I have some clarifications. It is not possible to create a single table that contain all the validations because the 1st table contains a project name at multiple times but the next table contains a project name only one time and also it validates the different values. So kindly tell me any other idea to simplify this task by not combining all the tables. Actually I need to filter the every table by using the project name as common.

Thanks,
Karthik

It is possible to create a single table. You are maybe misunderstanding the point. All you need is to ensure you have a unique name for each DIFFERENT field. For instance the Project ID appears in all tables so you only need one field. Ditto the Project Name etc.. The validations you have are the same in all tables so I don;t see why you see a problem with a validation in a single table.

I'm attaching in sheet 3 your tables combined into a single table.